Error in dataflow refresh

[msahari]

While working on dataflow, it's difficult to say when will it show error as for my case it didn't showed up any error in query. but showed up error after refresh. till now i was able to debug it but this one "Error: On-Prem execution not supported for entity '68c802b0-100d-4cfa-a4e7-15f37e03ce5e/5247a5fd-2058-419e-9fc0-7f0f14b1ef1b/Prod date' since it refers to another entity.. Param1 = 68c802b0-100d-4cfa-a4e7-15f37e03ce5e/5247a5fd-2058-419e-9fc0-7f0f14b1ef1b/Prod date Request ID: 274dbd2a-b9bc-6b25-c930-72309ceedea2."

Can anyone please help me in this?

[msahari]

I think people need more details, i have 2 tables in dataflow which is getting load nicely, adn the table showing error uses merge query for getting useful columns which is working fine in desktop with same code.

[Anonymous]

Hi @msahari ,

You can open the Excel file and check for obvious errors or inconsistencies in the table. Make sure that all data types are correct and that there are no missing or corrupt values. Also, make sure that the table has the correct header rows and that there are no merged cells, as these can sometimes cause problems when importing data.

Also, here are some solutions to problems similar to yours that I hope will help you.

Solved: Dataflow: On-Prem execution not supported for enti... - Microsoft Fabric Community

Solved: Dataflows: Error: On-Prem execution not supported ... - Microsoft Fabric Community

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[msahari]

Can you please tell once what do you by "make sure that the table has the correct header rows and that there are no merged cells, as these can sometimes cause problems when importing data."

[collinq]

Hi @msahari 

Along with the response from @Rigensis , you may want to refer to this thread that had a solution for the same problem:

Solved: On-Prem execution not supported for entity - Microsoft Fabric Community

I also found this response to a similar issue:

The answer in this case was to untick the Enable load option on the linked entity.

[Rigensis]

Most likely the error does not show up in the query before full refresh, as then only the first 1000 rows are tested, and the error might be happening in a later row.
if the error message doesn't show you which table is the problematic one, I'd suggest you to create another dataflow where you change the tables one by one, then see after refreshing which one you get the same error, then you'll know within which table the error resides, and look for the faulty data entry within the table then.

[msahari]

cel download i am getting excel from which I am getting table have error.