cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
seryil Helper II
Helper II

Dataflow: On-Prem execution not supported for entity

Hi all,

 

I hope someone can help me with my problem.

 

I have a dataflow that contains two tables from SQL Server on-prem. The first table is Employees and the second is Sales. In Sales, I only have the name of the person that sold the product but not her/his Person_ID. The Employee table contains Person_ID so I merge the two tables and now the Sales table also has Person_ID. The Sales table now has a "lightning icon". 

The problem is that after I do the merging and then try to manually refresh the Dataflow I get this error: On-Prem execution not supported for entity

The Workspace is part of the Premium capacity and I'm using an Enterprise Gateway. Can someone explain to me why I get this error and how to fix?

3 REPLIES 3
Super User I
Super User I

Re: Dataflow: On-Prem execution not supported for entity

Hi @seryil,

Did you untick the Enable load option on the linked entity?

That way the linked entity will not load, but only the merged entity.



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


Blog: nickyvv.com | @NickyvV


Community Support
Community Support

Re: Dataflow: On-Prem execution not supported for entity

Hi @seryil ,

 

Is the method provided by @nickyvv  effective?

 

 

Best Regards,

Icey

seryil Helper II
Helper II

Re: Dataflow: On-Prem execution not supported for entity

Hi @Icey and @nickyvv ,

 

But why should I enable load when I need both tables? And my workspace is part of the premium capacity so why is this necessary?

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.