Power BI unable to connect XLSB file

[Anonymous]

Hi Community, 

When i try to connect an xlsb file on my local machine- i get this error

But, when i try to do the same thing on remote server- it does work there. I know these are 2 different machine. 

May be some software needs to be installed on my local machine. Can somebody please guide on the next steps?

Thanks

[amitchandak]

@Anonymous ,

check

https://www.mikesdotnetting.com/article/280/solved-the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-mach

https://stackoverflow.com/questions/6649363/microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine

https://www.layer2solutions.com/support/business-data-list-connector-faqs/how-to-access-office-2010-data-from-sharepoint

You can change two older version and use(office 97-2003)

[Anand24 · Accepted solution]

Hi @Anonymous ,

Seems like "Microsoft.ACE.OLEDB.12.0" is not registered in your local machine but appropriately registerd in remote server.

Thats why you are facing error in one while conencting smoothly in other.

Look at the last line in your error message and they have provided the link from where you will have to install client software.

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

[Anand24 · Accepted solution]

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!