Forum Discussion
Helper VError: On-Prem execution not supported for entity"
So actually, this is quite an easy answer, and doesnt require turning off loads.
In Short, do the following:
Query 1 (Data Pull) - This is main data pull in query. Do as little as needed to the data (normally ensure that all columns are in a data format). Do nothing else.
Query 2 (Data Pull Reference) - Create a reference to the above Datapull, do nothing, but ensure its well labelled. This is what your going to use for further queriesQuery 3 (Main Query) In this query, make a reference to the above Query 2 and then do all your maniupulation. Any other queries you need to bring in, ensure you have done the the other two queries, so all you are bringing in is a referenced query.
Works a like a dream.....
Community SupportHello BugmanJ
Thank you for reaching out to the Microsoft Fabric Community.
Thank you GilbertQ for your prompt response.
The error "On-Prem execution not supported for entity" typically occurs when a dataflow references another entity that requires an on-premises gateway, but the gateway settings are not properly configured or supported for the specific entity.
- Make sure the gateway settings for the dataflow are correctly configured. If the gateway is locked, you may need to edit the dataflow settings to unlock it.
- Add an entity from another dataflow using the Power BI dataflow connector. When prompted to switch to Power BI dataflow mode, accept and proceed. After adding the entity, you can delete it. Save the changes and refresh the dataflow.
- Untick the "Enable load" option on the linked entity. This has been reported to work for similar issues.
If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.
Thank you!
BugmanJActually this didnt help me at all, but see the next post for an easy solution!