Dataflow (gen1) fails after Join operation

Hi Anonymous ,

This error is triggered due to the dependencies with the source “Orders”  tables, where the latter is the one that necessitates the use of on-premises gateway, from the merged entity.

you can check below things if this is enabled 

First, navigate to the dataflow settings and ensure the “Enable load” for the linked entities’ “Orders”  checkbox is not ticked .

By refreshing the data in the cloud first, and then using the reloaded data for merging he can thus bypass the on-premises gateway.

Instead of merging the tables directly, create a reference with the original tables in the dataflow. Consequently, this will enable him to use the cloud-based source of the dataflow entities during the refresh rather than relying on on-premises gateway.

Hi mohitkumawat ,

Thanks for your assistance.

When you say dataflow settings, I cannot really see any load options here:

If you are referring to this 'enable load' then I can confirm it is now off on all tables but now the dataflow won't validate

Am I missing something?

Also are you suggesting that before every merge I create a reference table and merge those instead?

Thanks,