XLSB files with low performance

[Anonymous]

Hi Community, 

When I try to connect an XLSB file I'm experiencing some performance issues. But if a take the same file and save as XLSX, it works perfectlly.

Does anyone know why? Is it possible to fix or avoid?

[Fowmy · Accepted solution]

@Anonymous 

XLSB is a binary format and it is always a good idea to have in XLSX or CSV formats if you are experiencing performance issues.

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn 

[v-alq-msft · Accepted solution]

Hi, @Anonymous 

It is suggested to use XLSX, which is much faster than XLSB. I'd like to suggest refer to the following link for help.

Power Query: Xlsb vs Xlsx 

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Fowmy · Accepted solution]

@Anonymous 

XLSB is a binary format and it is always a good idea to have in XLSX or CSV formats if you are experiencing performance issues.

________________________

If my answer was helpful, please consider Accept it as the solution to help the other members find it

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube  LinkedIn