Dataflow: On-Prem execution not supported for entity

[Anonymous]

Hi all,

I hope someone can help me with my problem.

I have a dataflow that contains two tables from SQL Server on-prem. The first table is Employees and the second is Sales. In Sales, I only have the name of the person that sold the product but not her/his Person_ID. The Employee table contains Person_ID so I merge the two tables and now the Sales table also has Person_ID. The Sales table now has a "lightning icon". 

The problem is that after I do the merging and then try to manually refresh the Dataflow I get this error: On-Prem execution not supported for entity

The Workspace is part of the Premium capacity and I'm using an Enterprise Gateway. Can someone explain to me why I get this error and how to fix?

[Anonymous]

Do you have a conclusion for this question?

[Icey]

Hi @Anonymous ,

Is the method provided by @nickyvv  effective?

Best Regards,

Icey

[Anonymous]

Hi @Icey and @nickyvv ,

But why should I enable load when I need both tables? And my workspace is part of the premium capacity so why is this necessary?

[nickyvv]

Hi @Anonymous,

Did you untick the Enable load option on the linked entity?

That way the linked entity will not load, but only the merged entity.

[sxt173]

But does the linked entity still refresh if Enable Load is disabled? Kind of pointless if it's stale data being merged.