cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
rizwansajwani
Regular Visitor

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: https://go.microsoft.com/fwlink/?LinkID=285987.</ccon>. </ccon>. The exception was raised by the IDbCommand interface. Table: DAILYFILE.

\\Error Message End

 

Thank you.

 

Regards

Riz

0 REPLIES 0

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.