Forum Discussion
DataSource not found
DataSource.NotFound: 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 OLEDB provider may be required to read this type of file.
What to do ? how to download and configure? My data isnt refreshing.
Please advise !
Hi,
You might be getting this error because Power BI (or Excel/Power Query) is trying to access an Excel file using the Microsoft.ACE.OLEDB.12.0 provider, but that provider isn't installed or correctly configured on your system. Please check if this works,
- Download: Access Database Engine 2016 (64-bit) - Pick AccessDatabaseEngine_X64.exe.
- Install it (run as Admin).
- If error: use Command Prompt if 32 bit of office installation - AccessDatabaseEngine_X64.exe /quiet
- Restart Power BI / Excel.
- Refresh your data.
Thanks,
Bhavin
9 Replies
What is your data source? Are you trying to connect to Access but don't have it installed?
The data source is sharepoint.
I had the same issue, because I used the xls file in Sharepoint.
Please check your Excel version what is used in Sharepoint and your power BI. You might use xls file. If yes, you can resave your old Excel file to the xlsx and change it is your power BI desktop too.
Hi,
You might be getting this error because Power BI (or Excel/Power Query) is trying to access an Excel file using the Microsoft.ACE.OLEDB.12.0 provider, but that provider isn't installed or correctly configured on your system. Please check if this works,
- Download: Access Database Engine 2016 (64-bit) - Pick AccessDatabaseEngine_X64.exe.
- Install it (run as Admin).
- If error: use Command Prompt if 32 bit of office installation - AccessDatabaseEngine_X64.exe /quiet
- Restart Power BI / Excel.
- Refresh your data.
Thanks,
Bhavin
I did this, but still having same issue.
BhavinVyas3003 I downloaded and installed 64 bit databse engine access as mentioned above, but still having error and its not allowing me to install 32 bit version.
please advise !
If you're getting the Microsoft.ACE.OLEDB.12.0 error while connecting to an Excel file stored on SharePoint, it's may be because you're using the Excel or Web connector, which tries to use local OLEDB drivers.
Use the SharePoint Folder connector instead:
In Power BI: Get Data → SharePoint Folder
Enter your site URL
Authenticate if prompted
Filter to your Excel file and click Combine & Load
I did the same earlier.
- i am connected to my shrepoint folder only, its still having same error message.Last refresh failed: 5/1/2025, 10:17:22 PM
There was an error when processing the data in the dataset.Hide detailsData source error: DataSource.NotFound: 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 OLEDB provider may be required to read this type of file. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987.. Microsoft.Data.Mashup.ErrorCode = 10478. . The exception was raised by the IDbCommand interface. Table: ATM ALL. Cluster URI: WABI-NORTH-EUROPE-F-PRIMARY-redirect.analysis.windows.net Activity ID: 636970cf-173b-4e81-9a66-9b535928431e Request ID: 00e8b65e-09b3-9145-631a-b912ecad2164 Time: 2025-05-02 02:17:22Z
