Solved: dataflow source data

Ralphatech · ‎03-24-2021

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 · ‎03-24-2021

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.

Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling

Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

edhans · ‎03-24-2021

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.

Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling

Proud to be a Super User!

MCSA: BI Reporting