0

so I read that Excel binary format is faster and better, so I saved my table in this format. Unfortunately I found out that my other workbook which was importing one sheet from this now has problems and when I try to import that sheet again from this xlsb file it says DataFormat.Error: External table is not in the expected format So is XLSB just unusable as data source for other workbooks?? Do I have to save it back as XLSX?

Improve this question
2
  • Take a look at Importing xlsb into Power BI. I have also read something about it being possible if you only have one table per worksheet. And that the connector is less efficient reading xlsb vs xlsx
    – Ron Rosenfeld
    Oct 15, 2021 at 11:24
  • And I have certainly been able to import xlsb into both Power Query in Excel, and also Power BI Desktop, although for the latter I had to install an old Access connector. It is written, however, that the import process is more efficient using the more modern file types (xlsx/xlsm)
    – Ron Rosenfeld
    Oct 15, 2021 at 11:37

1 Answer 1

Reset to default
0

OK so if nobody says otherwise I consider Excel binary format incompatible with PowerBI

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .