Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Manasi25
Helper II
Helper II

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 !

1 ACCEPTED SOLUTION
BhavinVyas3003
Super User
Super User

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,

  1. Download: Access Database Engine 2016 (64-bit) - Pick AccessDatabaseEngine_X64.exe.
  2. Install it (run as Admin).
  3. If error: use Command Prompt if 32 bit of office installation - AccessDatabaseEngine_X64.exe /quiet
  4. Restart Power BI / Excel.
  5. Refresh your data.

Thanks,

Bhavin


Thanks,
Bhavin
Problem solved? Hit “Accept as Solution” and high-five me with a Kudos! Others will thank you later!

View solution in original post

8 REPLIES 8
BhavinVyas3003
Super User
Super User

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


Thanks,
Bhavin
Problem solved? Hit “Accept as Solution” and high-five me with a Kudos! Others will thank you later!

  - 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

@BhavinVyas3003

I did the same earlier.

BhavinVyas3003
Super User
Super User

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,

  1. Download: Access Database Engine 2016 (64-bit) - Pick AccessDatabaseEngine_X64.exe.
  2. Install it (run as Admin).
  3. If error: use Command Prompt if 32 bit of office installation - AccessDatabaseEngine_X64.exe /quiet
  4. Restart Power BI / Excel.
  5. Refresh your data.

Thanks,

Bhavin


Thanks,
Bhavin
Problem solved? Hit “Accept as Solution” and high-five me with a Kudos! Others will thank you later!

@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.

danextian
Super User
Super User

What is your data source? Are you trying to connect to Access but don't have it installed?





Dane Belarmino | Microsoft MVP | Proud to be a Super User!

Did I answer your question? Mark my post as a solution!


"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

The data source is sharepoint.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.