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
dax's avatar
dax
Community Support
6 years ago

Hi Anonymous , 

I don't know how you refer to another entity in dataflow, could you please explain this to me in details? Then I will try to test this in my environment. Or you also could try to use linked entity to see whether it work or not, you could refer to service-dataflows-linked-entities (you also  could check the limits in this link) for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • 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?