The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 !
Solved! Go to Solution.
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,
Thanks,
Bhavin
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 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 details
Data 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 exce... |
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 |
I did the same earlier.
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,
Thanks,
Bhavin
@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 !
I did this, but still having same issue.
What is your data source? Are you trying to connect to Access but don't have it installed?
The data source is sharepoint.
User | Count |
---|---|
75 | |
70 | |
39 | |
30 | |
28 |
User | Count |
---|---|
104 | |
95 | |
51 | |
48 | |
46 |