Forum Discussion

mark_carlisle's avatar
mark_carlisle
Icon for Advocate IV rankAdvocate IV
7 years ago
Solved

Dataflows: Error: On-Prem execution not supported for entity

I'm encouting an error when using dataflows;   Error: On-Prem execution not supported for entity 'REDACTED/Rant&RaveGlobal' since it refers to another entity... RootActivityId = REDACTED.Param1 = R...
  • mark_carlisle's avatar
    mark_carlisle
    7 years ago

    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.

otravers's avatar
otravers
Icon for Community Champion rankCommunity Champion
4 years ago

Yes it's a hassle that you can't merge queries from on premises sources. You could try creating a separate dataflow for staging tables.

sxt173's avatar
sxt173
Icon for Advocate II rankAdvocate II
4 years ago

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?