Forum Discussion

sovereignauto's avatar
sovereignauto
Helper III
4 years ago

Dataflow - Onprem gateway - enable load

Good Afternoon,

 

I have a dataflow set up in which i merge some queries, when doing this on the desktop i "untick" enable load so that it is only loaded through the merged query to save a full load of the second table.

 

When i do this on the dataflow i get an error of "on-Prem execution not supported for entity....... since it refers to another entity..." 

 

Does this mean we have to load the full table in order or merge? 

 

Thank you!

Need Help
Show and Tell

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi sovereignauto ,

     

    Try to untick the "unable load" on the entity that is used to merge. Because if the merged table has another query applied to it, it will cause it to ignore that setting and refresh it again. For a related example, see the similar solution.

    Microsoft Idea  · Exclude a table from refresh in Power BI Service


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your feedback.

    Best Regards,

    Stephen Tao


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

    • sovereignauto's avatar
      sovereignauto
      Helper III
      4 years ago

      Good Morning Anonymous 

      Unticking "Enable load" is what causes the error. The below is the error i get on the DF export: 

      Error: On-Prem execution not supported for entity '0e4e5bdf-1db2-4005-be0e-ff79bf9f4896/bab9e945-20fd-4dec-bdad-583e8ed61f3f/ACCIDENT' since it refers to another entity.. RootActivityId = 1a2dbb8d-1f2a-4982-95ff-643fb75a1016.Param1 = 0e4e5bdf-1db2-4005-be0e-ff79bf9f4896/bab9e945-20fd-4dec-bdad-583e8ed61f3f/ACCIDENT Request ID: 7616f210-9c28-2b93-14ae-82d1103f12bb.