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.
So if I go with the solution of turning off Enable Load, I'm basically left with stale data coming from the Parameter Entity that I'm trying to merge from, correct?
And the real solution right now is to stage the Parameter Entity in a different Staging Dataflow and then merge that into my Dataflow?
It shouldn't be stale if Enable Load is off, it just won't be materialized as data in the underlying data lake (at least that's how I think it works) and it won't be visible from outside of the dataflow.
Having separate staging dataflows is more elegant and it might save you in some instances from loading the same table twice in case that table needs to be materialized/visible outside of the dataset.