is Xlsb file stilll doesn't support in power BI

[vjnvinod]

hi,

I was trying to load Xlsb file, but some error is coming would that mean, xlsb files are not support yet in power BI?

[v-cherch-msft]

Hi @vjnvinod

You may have a look at the below articles.

https://exceleratorbi.com.au/importing-xlsb-into-power-bi/

https://excelgorilla.com/power-bi/power-query/error-reading-xlsb/

Regards,

Cherie

[jcountryman]

@v-cherch-msft A year later and I'm encountering this problem, also. My organization feels .xlsb is the peferable format; is there a solution beyond these workarounds you've listed?

[FredQ]

Even many years later, it seems this is still a problem  I have 2 identical files, except 1 .xlsb and 1 .xlxs. They both have a field with 20.52 in it, the .xlsx imports the data as 20.52, but the .xlsb imports it as 21.00, no matter what format I use.