Forum Discussion

msahari's avatar
msahari
Frequent Visitor
1 year ago

Error in dataflow refresh

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 ...
Dataflow
Anonymous's avatar
Anonymous
Not applicable
1 year ago

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's avatar
    msahari
    Frequent Visitor
    1 year ago

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