Forum Discussion

Manasi25's avatar
Manasi25
Helper II
1 year ago
Solved

DataSource not found

DataSource not found BhavinVyas3003  here was an error when processing the data in the dataset. Hide details Data source error: DataSource.NotFound: Excel Workbook: The 'Microsoft.AC...
Need Help
  • v-sgandrathi's avatar
    v-sgandrathi
    1 year ago

    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's avatar
v-sgandrathi
Community Support
1 year ago

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.