Forum Discussion
Memorable MemberDataset Refresh error Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine
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:
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?
- GilbertQ
Super User
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-32-bit-processing/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 ....
- GilbertQHi 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/
