Forum Discussion
Dataflow failing refresh due to Advanced Data Transformations
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 🙂
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/m-p/629704
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.
1 Reply
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/m-p/629704
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.