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
Frequent Visitor

Hello I experienced that problem, maybe the reason is Excel File is Read-Only or you don't have the permission to edit it, So maybe it is better to convert it to CSV or Text

Frequent Visitor

I believe I fixed this problem! Use the data gateway to refresh this source.

 

1. Install a data gateway

2. Add the XLS data source to the data gateway

3. Check the box to Allow user's cloud data sources to refresh through this gateway cluster. These cloud data sources do not need to be configured under this gateway cluster.

4. Set the data source to refresh through the gateway

5. Refresh your dataset

@devhawkio 

 

Thanks a lot, I will try it and let you know how it works. 

 

Best,

Jorge

Advocate V
Advocate V

The only workaround is to save the xls files as xlsx, worked for me.

 

Annotation 2019-10-31 123359.png

 

Anonymous
Not applicable

Hi,

 

I'm facing the very same problem but with a xlsb extension. It works fine on Power BI Desktop but when I publish to Power BI Service and try to refresh the dataset I got this error:

 

2018-12-14 14_10_19-Power BI.png

 

Is there any prevision when this will be fixed?

 

Thanks

Hello I have same problem, Power BI in 64 bit, office in 64bit, the excel is xlsb stored on cloud!

 

How it is possible to solve?

Hi there

You should just install both versions of the driver.

This can be done using the blog post below

https://datasavvy.me/2017/07/20/installing-the-microsoft-ace-oledb-12-0-provider-for-both-64-bit-and...




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

I have been installed and issue is not solved

C:\Users\rdedonat\Downloads>AccessDatabaseEngine.exe /passive

C:\Users\rdedonat\Downloads>AccessDatabaseEngine_X64 /passive

I have Power 64 and Office 64 bit

the excel workbook I am reading are *.xlsb,

 

after 10 minutes the refresh on web service goes in error because I suppose the number of rows / tuples is reacheing more than one milion ....

 

Hi there

As far as I know *.xlsb is not supported in the Power BI Service.

Convert it to a *.xlsx and that should solve it.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Hi there

As per the details below it would need to be XLSX or XLSM

https://powerbi.microsoft.com/en-us/documentation/powerbi-service-excel-workbook-files/




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Advocate III
Advocate III

Hi all,

 

I have experienced the same issue and no luck trying to change the file or making the installation Passive.  Is there another way to automatically change the file extensions at the moment? 

Advocate II
Advocate II

Hello , an option to solve this issue is create a Power Query since web, save like an xlsx file and connect this new query with the Power BI. 

 

 

Super User II
Super User II

Hi there

 

Could a potential work around be for now, to use Power Flow, and download the file to OneDrive, and then from there Power BI can then connect to the file via OneDrive?

 

In doing it that way, the Power BI Service will be able to refresh every 15 minutes which is the default setting. As well as the Power Flow downloading the file to the same location?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

@GilbertQ your sugested work around of using MS FLow could be an option. However, I have looked at Flow and can not see any easy way to be able to download a file from the web to One Drive. Can you give me some pointers on how you would do this. Thank you very much.

Hi there, here is an example from Microsoft

 

https://flow.microsoft.com/en-us/documentation/get-started-logic-flow/ 

 

And when you get to adding an action, change that to an Excel File.

NOTE: You will have to see the format of the data you are getting and create a table in Excel that represents this dataset. 

NOTE II: Also ensure that you save your Excel File in OneDrive for Business, as this will mean that you can quickly connect to it via the Power BI Service or Power BI Desktop (and get 15 minute automated refreshing)

 

So when you make the action to an Excel file, you will be able to map the output columns to columns in your Excel File.

 

Then once that is done your data source should be updated automatically.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

@GilbertQ that sounds interesting, but that link you posted gives a 404. I tried browsing from the home page but couldnt find what you described.

Hi there,

 

Apologies if you can try this link please.

 

There is a wealth of information and documentation on their website.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

@GilbertQ - it looks like you left the new link off that last message?

Sorry about that here it is:

 

https://flow.microsoft.com/en-us/documentation/get-started-logic-flow/





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

@GilbertQ thanks for the idea in principal it sounded good. However, as I expected you still run into the problem that Power BI can not update from a xls file even when it is saved on OneDrive. The error message is the same as @mike_honey was getting as shown below. Given that Power BI and OneDrive are both in the cloud it is obviously not possible to run the client software. @Vicky_Song any updates or sugested work arounds.

 

 

  
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 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

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

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!.

Top Solution Authors