DataSource not found

[Manasi25]

DataSource not found—I downloaded and installed 64-bit and 32-bit ACCESS DATABSE Engine to resolve t...

@BhavinVyas3003 

here 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

[Manasi25]

Thank you for reply !
The one cause i found is all my Excel files are in .xls format and its auto uploading on sharepoint from one tool.
Is it also be the problem for this error?

[v-sgandrathi · Accepted solution]

Hi @Manasi25,

Yes, the .xls format is likely causing the error. Power BI Service has limited support for older .xls files, as it relies on the Microsoft.ACE.OLEDB.12.0 driver, which doesn't work well with .xls in cloud environments

To resolve this, it's recommended to use the modern .xlsx format, which is better supported by Power BI both in Desktop and Service environments. If your automation tool is uploading .xls files to SharePoint, consider modifying it to generate .xlsx files instead. Alternatively, you can use Power Automate to set up a flow that converts .xls files to .xlsx automatically upon upload to SharePoint. This would ensure better compatibility with Power BI and eliminate the OLEDB-related errors during dataset refreshes.

Thanks for reaching out! If this answer was helpful, please consider marking it as Accepted Solution and giving a Kudos, it helps the community!

Thank you.

[v-sgandrathi]

Hi @Manasi25,

Here are the next steps you can try:

Use the Web Connector instead of Excel Workbook connector:

Copy the direct link to your Excel file from SharePoint (ensure it ends with .xlsx).

In Power BI Desktop, go to Get Data > Web and paste the SharePoint file URL then authenticate with your Organizational Account and publish the report to Power BI Service.

If the file is stored locally or on a network drive, you need to use the Power BI On-Premises Data Gateway for successful cloud refreshes. You can install the gateway and configure it to connect to local files for Power BI Service.

If the issue continues after following the above steps, we recommend contacting Power BI Support by submitting a support ticket so that team can perform a more detailed investigation and assist with any environment-specific configuration issues or potential service-related limitations.

Thank you.