Power BI doesn't recognizeMicrosoft Access Database Engine

[liliachante]

Hi,
I have an issue with power BI, I have the version 64 bits and office 32 bits, I can open xls file , but I can't open xlsb file. I got the following message:
the Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. the IT of my organisation install the package Microsoft Access Database Engine. But I've got the same error message. power BI doesn't recognize the package. How can I do the link with power bi destop in order to integrate this package.

Thanks for your helps,
Best regards,

[v-alq-msft]

Hi, @liliachante 

I'd like to suggest you install the corresponding 32 bits version of Power BI Desktop, which will work properly with your Microsoft Access Database.

Best Regards

Allan

[Anonymous]

You will need to install Microsoft Access Database Engine 2010 Redistributable.

https://www.microsoft.com/en-in/download/details.aspx?id=13255

Ensure that you install 32 bit and not 64 bit even if your OS is a 64 bit

[rajendraongole1]

You can download 32-bit Power BI Desktop from this https://www.microsoft.com/en-us/download/details.aspx?id=58494

And make sure that you also download and install 32-bithttps://www.microsoft.com/en-in/download/details.aspx?id=13255, then you should be able to connect to Access database from Power BI Desktop.

If this post helps, then please consider and accecpt it as solution.