Forum Discussion

_onto_'s avatar
_onto_
Helper I
2 years ago

Error: On-Prem execution not supported for entity - what does this mean, exactly?

Hello,   I have a dataflow sourcing data from MS SQL Server (via an enterprise gateway) and some files on Sharepoint. The dataflow saves fine but on refresh I get **"Error: On-Prem execution not su...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi _onto_ ,

 

"Error: On-Prem execution not supported for entity...", typically indicates that there is a problem with the configuration or compatibility of the on-premises data gateway that you're using to connect to your MS SQL Server.

 

During our investigation of this issue we found that there have been users who have had experiences similar to yours. you may troubleshoot it in the following methods：

1.Check the gateway of the dataflow in setting and make sure it is not locked.
2. Add any entity from another dataflow using Power BI dataflow connector, then delete it.
3.Untick the Enable load option on the linked entity.
4.Create a reference to the tables you want to merge instead of merging them directly.
5.Copy the original table and use the copied table to merge.

 

For original post, you may refer to Solved: On-Prem execution not supported for entity - Microsoft Fabric Community

 

Best regards.
Community Support Team_Caitlyn