cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ScottR-MT Regular Visitor
Regular Visitor

Power BI Service Failing to Refresh Excel Files

Hi,

 

I just recently started having problems refreshing Excel files on a SharePoint on the Service, when everything was working fine before.  I have no issues refreshing with PBI Desktop.  I am getting the error at the bottom of this message.  To date, I have already removed and reinstalled the Access Database Engine 2010 x64 - to no avail.

Republished one of the failing datasets/visuals.

 

I am running Windows 10 64 bit, Office 2016 64 bit, and Power BI 64 bit, and also have the 64 bit version of the Data Gateway installed.


This has brought almost all of my published work to a halt.  Please help!

----------------------------------------------------------------------------------------------

Something went wrong
There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
Data source error: 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 2010 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.. The exception was raised by the IDataReader interface. Table: xxxxxxxxxxx.
Cluster URI: WABI-US-EAST2-redirect.analysis.windows.net
Activity ID: 10ba4172-cab6-46d7-a6d2-a839d57cafbc
Request ID: 58524e8a-8976-4f93-8a79-15ba0af86235
Time: 2019-01-30 13:21:46Z

3 REPLIES 3
v-yulgu-msft Super Contributor
Super Contributor

Re: Power BI Service Failing to Refresh Excel Files

Hi @ScottR-MT,

 

Please check is you installed both 32-bit version and 64-bit version of Access Database Engine on your machine.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ScottR-MT Regular Visitor
Regular Visitor

Re: Power BI Service Failing to Refresh Excel Files

Hi,

 

I only have the 64 bit version of the Access DB Engine installed, which matches my Windows 10, Office 2016, and Power BI versions.

kgmccann Regular Visitor
Regular Visitor

Re: Power BI Service Failing to Refresh Excel Files

@ScottR-MT Did you ever find a solution to this? I am having the same problem. Works on Desktop, not in service. When the scheduled refresh is attempted it gives me the same error you had.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 59 members 1,120 guests
Please welcome our newest community members: