Forum Discussion
DataSource not found
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
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 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 |