Showing results for 
Search instead for 
Did you mean: 
New Member

Power BI cloud datasets refresh setup & run has an error

Hi team,


I have published one report to Power BI cloud services and setup the refresh functionality. all data source credentials defined successfully, however at the time of auto refresh I got following refresh failure message and after review of this I understood this because of one file extension is "XLS" is causing this refresh functionality failure. The file with this "XLS" extension can not be converted to any other readable format because this file is being generated on daily basis by default from another application and available on network path.


Now, I am looking for solution which allows this "XLS" extension file to be refresh in cloud service without any failure error. The error message is as follow for your reference.


\\Error Message Start

Refresh failed:

Retail Sales Report has failed to refresh.
Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

<ccon>DataSource.NotFound: <ccon>Excel Workbook</ccon>: <ccon>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:</ccon>. </ccon>. The exception was raised by the IDbCommand interface. Table: DAILYFILE.

\\Error Message End


Thank you.





Helpful resources

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.