dataflow source data

[Ralphatech]

Hi team,

Has anyone come across difficulties importing data from a '.xlsb' file.

I am able to successfully import data from a xlsx file to dataflow but because of storage issues I resaved the .xlsx file as .xlsb but the dataflow does not succeed while importing it.

The navigation step does not progress.

Anybody aware of such an issue? 

Thanks!

Ahuja

[edhans · Accepted solution]

You should assume this isn't supported. XLSB files are not XML files like all other office documents. They are closer to the original XLS format. Even in Power BI there are issues with XLSB files. Use XLSX for your data sources.