topic Re: Error in dataflow refresh in Service

Error in dataflow refresh

msahari — Fri, 20 Sep 2024 10:50:55 GMT

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?

Re: Error in dataflow refresh

Rigensis — Fri, 20 Sep 2024 12:13:51 GMT

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.

Re: Error in dataflow refresh

collinq — Fri, 20 Sep 2024 20:54:13 GMT

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.

Re: Error in dataflow refresh

msahari — Mon, 23 Sep 2024 04:45:13 GMT

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

Re: Error in dataflow refresh

Anonymous — Mon, 23 Sep 2024 05:43:07 GMT

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.

Re: Error in dataflow refresh

msahari — Wed, 25 Sep 2024 05:04:38 GMT

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.

Re: Error in dataflow refresh

msahari — Wed, 25 Sep 2024 05:06:45 GMT

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."