Forum Discussion

Ant_C's avatar
Ant_C
Frequent Visitor
1 year ago

Dataflow on Excel - Error

Hello,

I have a dataflow connected to an excel file in sharepoint, reading data in columns in a normal sheet (no table formatting) and I receive this error everytime it refreshes :

 

 

This file is dropped everyday by someone else and the dataflow refreshes after that.


I did some research and I only found this error linked to Google sheets but nothing really helpful.

The weird thing is that if I simply open the file, then rerun the dataflow, it works. If I don't open and rerun, it still fails.

Has anybody encountered this issue before ?

Thanks in advance for the help.

Regards

Dataflow
Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Ant_C ,

     

    Sometimes xlsx files, generated by the third side vendors, have errors in XML schema. Try to open this file in Excel and immediately save it, then close. 

    You can start by troubleshooting the error based on the following suggestions:

    1. Open the problematic Excel file and save it as a new file to see if the problem persists.

    2. Repair the Excel file using the built-in Open and Repair tool.

    3. Consider recreating the workbook and setting up a new connection to Google Sheets.

     

    I found something which could help.

     'Relationship Tag' error when trying to connec... - Page 2 - Microsoft Fabric Community

     

    Best Regards,

    Neeko Tang

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