Forum Discussion
Solved
Dataflow to SharePoint folder to combine XLSX files Error: DataFormat.Error: Root element is missing
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: DataForma...
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.
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.
otravers
Community Champion
Community ChampionYou 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