Forum Discussion
Dataflows: Error: On-Prem execution not supported for entity
As is customary with these situations, I spend time writing a question with an example and then I discover the answer.
The answer in this case was to untick the Enable load option on the linked entity.
I've tested a on demand refresh and scheduled and both worked.
Hi mark_carlisle ,
I faced the same situation using one entity as parameter in my dataflow to another entity in the same dataflow, and received this error message.
Actually I need to enable loading of that "parameter entity" for further usage. But after reading your solution, I did a workaround by disabling the loading of the "parameter entity" and create a new entity simply by linking the previous "parameter entity" and then the refresh works, although practically they are the same!
It is strange that by enabling the loading of the linked entity the dataflow refresh does not work. Is it planned by Microsoft to be like that?
Best regards,
cyongt_bdf
Can you describe in more detail what you did?
- What do you mean when you "create a new entity simply by linking the previous Parameter Entity"? Did you create a Reference to the Parameter Entity (for this purpose called "Parameter Entity_ref")?
- You use that Parameter Entity_ref to merge into Output Entity?
- You turn off the Enable Load for the original Parameter Entity?
The above steps don't work for me, I still get the same refresh error. The only way I can get it to work is to disable load on all Parameter Entities, whether I'm merging with the original or the _ref one.
Also, if the above were to work, is the Parameter Entity still refreshing? Since Enable Refresh is off, am I just looking at stale data?
Thanks