cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Patron
Post Patron

Merging queries from two linked entities in a dataflow leads to refresh error

Hi team,

Just wondering if it's not possible or I am doing something wrong.

So, I've created a beautiful dataflow, and an entity, "Opps", using Salesforce Objects. I set the incremental refresh to 'Last Modified Date'. Everything works.

Then I got greedy 🙂 In the same dataflow, I've brough in a linked entity, "Users", which also uses Salesforce Objects and has its own incremental refresh (providing you lots of details just in case one of them is relevant).

I've then used, in the dataflow, "merge queries', and I brought some columns of "Users" in "Opps". It was the classic Merge/Expand.

I saved the dataflow and there were no errors.

However, when I clicked on the dataflow refresh, I got an error 😞 Tried again with no success.

Is it really not possible to merge two entities in a dataflow?

Thank you in advance,

Alice

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Merging queries from two linked entities in a dataflow leads to refresh error

Hi @AliceW ,

 

As I know, using linked entities and merging entities, the dataflow need to be in Premium capacity. If you just have pro license, you could disable load the linked entity to implement refresh. 

1.gif

 

If this can't help you, please share the refresh error message.

 

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Post Patron
Post Patron

Re: Merging queries from two linked entities in a dataflow leads to refresh error

Hi Xue,

The dataflows are in a premium capacity (the diamond icon is there next to the name).

I've clicked on 'disable load' for the linked entities in the dataflow and.. they disappeared from the entities list.

All dataflows, if they are linked to this one, stopped refreshing.

This is the error message.

Run time,Dataflow name,Dataflow refresh status,Entity name,Start time,End time,Entity refresh status,Error,
02/06/2020 08:59:51,Opp,Failed,Opportunity,02/06/2020 08:59:51,02/06/2020 09:01:41,Failed,Error: We cannot apply operator - to types DateTime and Date... RootActivityId = cd7fb2dd-ca82-42e9-9ace-d13340775b94.Param1 = We cannot apply operator - to types DateTime and Date. Request ID: 6db10daf-15c5-0576-e89a-0511a8b217e2.

 

UPDATE: turns out that it was one of the calculated columns in the dataflow that prevented the refresh. Which is crazy, as the 'Save and Load' button for the dataflow PowerQuery worked w/o any issues!

 

Question: are we sure that, if I click 'disable load', the latest data from the linked dataflows will be brought over?

 

Thanks,

Alice

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors