Error in dataflow refresh

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.

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.

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.

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.