Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
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.
But does the linked entity still refresh if Enable Load is disabled? Kind of pointless if it's stale data being merged.