DataFlow Entity

[Salma123]

Hi,  

I have two dataflow

•  staging: 14 entities 
• Tranfosrmation : i use Staging entities ,  when I do " Merge Queries " a table FACT_MOUV With two Table, and then I do " Merge Queries As New " with another entity FACT_ENT in new Entity but In Refresh Dataflow is an error "Error: On-Prem execution not supported for entity '8eebce2c-5a9b-4c5f-bd13-defba1b26b8a/5ee5b195-52cb-4156-a5a9-496eb6b005f9/FACT_MOUV' since it refers to another entity... RootActivityId = e0c3df58-e939-4116-ae3c-61155aa0f6e6.Param1 = 8eebce2c-5a9b-4c5f-bd13-defba1b26b8a/5ee5b195-52cb-4156-a5a9-496eb6b005f9/FACT_MOUV Request ID: 6c47da9e-9ddd-a220-6e4f-cfaee0f6bec1."

Someone could help me!

[v-henryk-mstf]

Hi @Salma123 ,

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

Refer to similar solutions: Solved: Dataflows: Error: On-Prem execution not supported ... - Microsoft Power BI Community

Best Regards,
Henry

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

[jeffshieldsdev]

Are you using an on-prem gateway? You don't need to select a gateway for your dataflow merging other dataflows. It can be deselected in the Project Options dialog.