Forum Discussion

vqps8866's avatar
vqps8866
Advocate I
6 years ago

Error Message to collect data from excel.

Hello All   I would like to ask support because I'm getting an error message when I'm trying to collect data from excel Someone could send me what i have to do? The database engine 2010 was i...
Need Help
vqps8866's avatar
vqps8866
Advocate I
6 years ago

Hello Icey 

 

How are you?

 

Steps didn't solve the issue.

I had to copy the information from xlsb file and move to another excel file xlsm.

In my opinion, the power bi can't collect any data from excel file extension xlsb.

 

Many tks for your time and attention.

Icey's avatar
Icey
Community Support
6 years ago

Hi vqps8866 ,

 

Yes, Power BI Desktop doesn't support to connect directly to XLSB file currently.

Here is an idea about Excel Binary file supporting, and you can vote it up.

And I find that someone was able to fix this connection issue by downloading the Microsoft Access Database Engine 2010 Redistributable.exe file from this link: https://www.microsoft.com/en-us/download/details.aspx?id=13255. Hope it also works for you.

 

 

Best Regards,

Icey

 

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