Power BI Error while connecting to XLS file (Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine)

Today I tried to open an older Excel file (with the extension XLS) in Power BI. After selecting the file in the Get Data dialog the following error was displayed:

image

@Power BI Team: First of all – Thanks for making the error message selectable which made the copy/paste action for the given link much much easier! Thanks!

Details: “Excel Workbook: The ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine. The 64-bit version of the Access Database Engine 2010 Access Database Engine OLEDB provider is required to connect to read this type of file. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987.”

On the given help link there is a step-by-step tutorial with the required things to check or even software to install.

Power BI Desktop needs Access Database Engine Redistributable for XLS Files

In short:  if your Power BI Desktop version is not the same CPU architecture type like your Office installation (in my case Power BI Desktop was 64 bit, my Office installation is 32bit), you’ll need to install the Access Database Engine runtime.

The download for MS Access Database Engine Redistributable can be found here. Be sure to check the same version as your Power BI Desktop is installed!

Immediate Success

The installation went smooth (just about 27MB download and a quick installation). And the best: I had my Power BI Desktop with the error dialog open, installed the Access Redistributables, switched back to Power BI Desktop and hit “Retry” and the import went well!

Advertisements

About wolfgang

Data Platform enthusiast
This entry was posted in Business Intelligence, PowerBI. Bookmark the permalink.

2 Responses to Power BI Error while connecting to XLS file (Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine)

  1. Vojta says:

    Thank you for the post. I am still experiencing the same issue though.
    Power BI Desktop 32 bit,
    Office Pro Plus 32 bit,
    Access 32 bit,
    WIN 10 64 bit
    and as I see under the link WIN 10 does not comply with the system requirements.
    Could this be the issue? In other words, the approach suggested works unless you have WIN 10?
    Thank you for your help.
    Vojta

  2. So this has always been a problem for 32-bit Office vs 64-bit OS and other 64-bit apps. Are you saying that you successfully installed the 64-bit Access Database Engine Redist on your 64-bit OS machine with 32-bit Office installed??? I have always gotten, and continue to get, an error stating that I can’t install 64-bit ACE if I have 32-bit Office. So the only option found was to install both 32-bit and 64-bit Power BI Desktops and use the 32-bit when trying to leverage Excel files as data sources. Is there a better way?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s