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:
@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 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!