Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dataflow Refresh Fail Since it Refers to Another Entity

I'm trying to move a dataset up to a dataflow and transferred everything by simply copying the advanced editor and pasting it into blank queries within the dataflow query editor.   After doing this...
Need Help
Tips and Tricks
arock-well's avatar
arock-well
Responsive Resident
5 years ago

I see there is no solution to this post. But, I'm having this exact same issue as Anonymous and L_G are having.

 

I have two tables in a dataflow that I pull in from on-prem SQL Server, Employee and Job. Refreshing the tables is not an issue.

 

However, once I merge Employee into Job and try to refresh the dataflow I get the following error: 

 

Error: On-Prem execution not supported for entity '777xxx/Job' since it refers to another entity.. RootActivityId = d9xxx.Param1 = 777xxx/Job Request ID: e0xxx.

 

When I remove the merge query, the dataflow refreshes as normal again.

 

What do I need to do to fix this?

Thanks

Aaron

sxt173's avatar
sxt173
Advocate II
4 years ago

Did anyone find a solution for this? One "solution" I saw on another thread was to uncheck "Enable Load" which defeats the whole purpose if you can't refresh your data.

And I don't understand the overall issue.. it's 2 SQL tables from the same exact DB. I can merge them in PowerBI and publish with on-prem Gateway. But I can't do the same in a Dataflow?