Power Query doesn't read an Excel file

Hey,

I had a different, but slightly similar problem a while back. After an update of the library that generates the excel-file, Power BI had problems with correctly reading the file. The solution i finaly found was the following (quoting):

PowerBI has an implementation of xlsx parser that doesn't work well with specific compression methods. In my case, Apache POI 5 defaults to Zip64 mode, a compression method that PowerBI's xlsx parser struggles with, while Microsoft Excel's xlsx parser seems to be able to handle just fine.

Our workaround is to set Apache POI's compression strategy to Zip64Mode.AsNeeded, as it was in Apache POI 4.


Changing this setting solved it for me. Maybe this might solve your problem too.