cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Power Participant
Power Participant

Dataset Refresh error Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine

I built a report using PBI Desktop - the source is an Excel file on a public website (not OneDrive).  When I publish it and then try to use the Power BI site to refresh the dataset, I get this error:

 

Data source errorExcel 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 is required to connect to read this type of file. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987.

 

 

Here's the source web page:

http://abs.gov.au/AUSSTATS/abs@.nsf/DetailsPage/5368.0Apr%202016?OpenDocument

 

Here's a sample URL to one of the Excel files on that page:

http://abs.gov.au/ausstats/meisubs.NSF/log?openagent&536801.xls&5368.0&Time Series Spreadsheet&A6970A1F22604DBBCA257FC50017F8C5&0&Apr 2016&02.06.2016&Latest

 

Any ideas how I can overcome this?  

41 REPLIES 41

@Vicky_Song any update on this?

Hello,

 

Is there any resolution to this problem?

 

I have xlsx files on One Drive for Business and accessed these files using Get Data-> Sharepoint folder and still the same problem occurs when i try to refresh through the Power BI Online Service. The same works fine on Power BI desktop though.

 

Any pointers appreciated.

 

Thank You,

Harisha

 

 

Hi All,

 

I do have the same issue. Any news ?

 

Best regards

 

Olivier

Bumping this thread. 

 

Anybody have a resolution for this? I am having the same issue currently.

Bumping this thread. 

 

Anybody have a resolution for this? I am having the same issue currently.

Advocate IV
Advocate IV

This one has also got 3 votes from me. We deal with a lot of ABS data and Power Query provides a great way to interact with the data. However, not being able to auto refresh the data is a killer for us. Is there any update on this one as it seems to have gone quite. This has been an ongoing issue and should be an easy one for MS to resolve. Thank you for any assistance that is provided with this.

Microsoft
Microsoft

Hi mike_honey,

How do you connect to the Excel file residing on public website from Power BI Desktop? By using the Web option as follows?
Capture.JPG

If that is the case, please help to check the above sample URL of Excel file and correct it. I am not able to open the sample URL and I can’t test it in Power BI Desktop.

In addition, what is the result after you install the Microsoft.ACE.OLEDB.12.0 provider?

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Here's the URL:

 

http://abs.gov.au/ausstats/meisubs.NSF/log?openagent&536801.xls&5368.0&Time Series Spreadsheet&A6970...

 

Note I'm not having any issues loading that file in PBI Desktop.  The provider is already installed and working on my machine.

 

The error occurs after publishing to PBI Web, and trying to use the dataset's REFRESH NOW link in PBI web.

 

Obviously I dont have any way to install it on the PBI Web machine.

Hi mike_honey,

I can reproduce the issue as yours. I will report it internally and post back once I get any update.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@mike_honey, the error message you got usually occurs when connect to .xls file. From the URL you provided, we can see that you try connecting to .xls file, I think that may be the reason why the error occurs. A similar thread you can check. 

 

So, please:

1). As suggested in that thread, use .xlsx file instead of .xls.

2). Download and install x64 Access Database Engine 2010 Access Database Engine OLEDB provider

 

If you still get the same error, please post back. 

@Vicky_Song

 option 1) is not possible - this is someone elses website (Australian Bureau of Statistics). 

option 2) is not possible - the only machine where this error occurs is on Microsoft's Power BI Web server, i.e. app.powerbi.com.  It works fine on my machine where that OLEDB provider is already installed.

 

Hi,

 

I've got exactly the same issue. Trying to pull XLS file from 'http://www.ofcom.org.uk/static/numbering/RID.xls'. Hope there will be an update soon.

 

Thanks,

 

 

Daniel

I've created an "Idea" for this issue - please vote it up.

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15081357-web-xls

 

3 votes!

@mike_honey, yes I see. I got the information from PG team that “refreshing against a .xls file is not supported”. So it will not work when users are trying to use the web datasource with .xls excel. I'm checking with the workaround, will post back when I got the information. Sorry for the inconvenience it brings you. 

Thanks for the update Vicky, but that seems quite ridiculous. A Microsoft-hosted web service doesnt support using a Microsoft driver to access a Microsoft file type? We can access 50 different web services (most of which I've never heard of, but they do sound cool), but not an Excel file?

@mike_honey, as this article described: "Power BI supports importing or connecting to workbooks created in Excel 2007 and later. Workbooks must be saved as .xlsx or .xlsm file type and be under 250 MB". Currently, you need to change files from type .xls to .xlsx in order to fix this issue.

 

I understand the issue you're facing and will report back to PG team about your concerns. 

Anonymous
Not applicable

Hello!

 

As far as I understand, no fix was put in place to allow .xls extension to be used as a source for Power BI online.

 

Did anyone find a solution for this issue? Is there any ideias on how to automate de file convertion for .xlsx or .csv fo instance?

 

Best regards.

Raphael Leis

I dont have any solution for this continuing annoyance.  The post in the Ideas forum for this issue only has 13 votes, which is a lot less than the comments on this thread.  Can all please vote early and vote often:

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15081357-web-xls

 

FWIW, my workaround is to use Power Update, a 3rd party scheduling product:

 

http://poweronbi.com/power-update/ 

@Vicky_Song are you able to provide any update on this. It is an ongoing known bug. Thank you.

@Vicky_Song is there any update on this one. As @mike_honey says it seems a liitle rediculus that you can not refresh xls files and should not be that hard to fix.

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

secondImage

The largest Power BI virtual conference

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

Top Solution Authors
Top Kudoed Authors