Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
A dataflow that combines a folder of .XLSX files from a sharepoint recently stopped refreshing.
Dataflow > sharepoint folder > filter to folder > combine files
Now I get:
Error: DataFormat.Error: Root element is missing.
Every time I recreate this with the same permissions I get this error when it was working fine for about 1 year before. Has there been a recent update to change the way .XML is being accessed?
Please help.
Solved! Go to Solution.
I found the problem and it was one of the (100s of) files in the folder. I just now have to find out which one.
It's not clear where in your query this error is occurring. Let's break it down into the smallest possible parts. Is your Source stage connecting to the SharePoint folder still working? Screenshots would help.
Thanks, there is nothing outside of basic data query functionality that I am doing here.
I create a "Sharepoint Folder" data query with a sharepoint connection that works fine for .csv file combining, but fails with these Excel files.
I filter to the folder in Sharepoint (I have tested this with a fresh connection to Sharepoint numerous times). Then use the "Combine Files" feature in the content column. It creates the helper query and converts each file (they are all identical excel files and only excel files are in that folder).
It errors when I just refresh the flow, and I can trigger the error in the dataflow editor when filtering by string values:
I found the problem and it was one of the (100s of) files in the folder. I just now have to find out which one.
You should be able to isolate the erroring row/file, probably best to do it from the Expanded step of your query.
https://radacad.com/exception-reporting-in-power-bi-catch-the-error-rows-in-power-query
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
50 | |
28 | |
23 | |
19 | |
13 |