Forum Discussion
Power Query - Self Referencing for Comments, but getting DataFormat.Error
Hi, So I recently made a file following the instructions in this https://exceleratorbi.com.au/self-referencing-tables-power-query/ . Recently, whenever I refresh I always get the error "DataFomat...
Hi MichaelRm
A DataFomat.Error in your scenario might be due to a DataSource file (your 4d1403fc-67ac-4180-8cdc-f6d019f3d6a3.XLS) generated by a system/application other than Excel
A bunch of apps generate incomplete/wrong Excel files. Although they (usually) can be opened with Excel, the Power Query connector for Excel files may fail opening/decoding them
Try to: Open your DataSourceFile in Excel > Save it > Close it > Refresh your query
If you can refresh the query you know where the problem comes from. Otherwise if there's nothing top secret in your DataSourceFile post it their (+ the workbook with your query)