Dataflow Refresh Fail

[RyanLeeMc]

Hello, 

I am having issues with my Dataflow data failing to refresh because of merged tables.  (I am on a Premium Per User licence)

I will try to explain the set up of the tables if this helps...

Table 1 - is made up of two tables appended together

Tabel 2 - is made up of four tables appended together

The refresh works fine at this points. 

I have then created a step to merge the two tables to pull in some info from table 1 to table 2.

When I create this step the tables become Computed tables and then the refresh fails for the following reason:

Error: On-Prem execution not supported for entity 'ca76d444-b093-4051-ae69-054c525b88bb/1170c024-9e81-4a70-96f1-dc10997851ab/bookings' since it refers to another entity.. RootActivityId = 32250dea-e2d6-4b4e-817b-d37d6d8ec282.Param1 = ca76d444-b093-4051-ae69-054c525b88bb/1170c024-9e81-4a70-96f1-dc10997851ab/bookings Request ID: c58c7180-957a-dd59-b1eb-34362bdec614.

Please can somebody help me 🙂

[v-luwang-msft · Accepted solution]

Hi @RyanLeeMc ，

Try to untick the Enable load option on the linked entity.

Similar case refer:

 https://community.powerbi.com/t5/Service/Dataflows-Error-On-Prem-execution-not-supported-for-entity/... 

For more information on the deep principles, you can refer to the following article:

https://radacad.com/workaround-for-computed-entity-in-power-bi-pro-dataflow-in-power-bi 

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien