Dataflow - Onprem gateway - enable load

[sovereignauto]

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!

[Anonymous]

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]

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.