Forum Discussion
Memorable MemberDataset Refresh error Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine
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?
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
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.