Forum Discussion
Memorable MemberDataset Refresh error Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine
Memorable MemberHere's the URL:
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
Vicky_SongImpactful Individual
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.
- mike_honey
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.
zondanAdvocate IV
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