Dataflow failing refresh due to Advanced Data Transformations

[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 🙂 

[Anonymous · Accepted solution]

Hi @RyanLeeMc 

In this case , you can try to untick the Enable load option on the linked entity.

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

Best Regard

Community Support Team _ Ailsa Tao

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