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