Forum Discussion
Helper IIRefresh Error - 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine.
Hi All,
I would like Power BI to auto-refresh but this error is preventing it from doing so - requiring me to refresh within PBI Desktop and publishing. I made sure to update my Power BI to a 64-bit version, however, I am still receiving an error. Again, this works fine in PBI Desktop... Any thoughts?
Data source error: [ValidateMarkupTags][ccon]DataSource.NotFound: Excel Workbook: [ccon]The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The 64-bit version of the Access Database Engine OLEDB provider may be required to read this type of file. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987.[/ccon]. [/ccon]. The exception was raised by the IDbCommand interface. Table: MarlinnRecByVendor.
The data sources are XLS - this is the type of file our reporting system creates. I know this causes issues but I would not be able to change multiple files each day to an XLSX file format.
9 Replies
- TheoC
Community Champion
Hi Tmk123
Since you've updated Power BI to a 64-bit version, ensure that you also have the 64-bit version of the Microsoft Access Database Engine installed. You can download it from the link provided in the error message.
Hopefully this will resolve the issue. If not, try to install both 32-bit and 64-bit ACE Providers (as sometimes there are some apps / software requiring 32-bit and others 64-bit).
Hope this helps!
Theo 🙂
Tmk123Hi Theo, thanks for your response.
I had to wait until my IT dept could work with me to install those files. Unfortunately, that did not work. I already had the 64-bit version of the file installed and then followed Step 4 in the following link: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-access-database-errors. I now have both 32-bit and 64-bit installed on my PC and still receive the following error when I try to refresh the data from my workspace. I can't be the only person that has to deal with data sources in an XLS format. Do you have any additional thoughts? I am stumped.
Data source error: [ValidateMarkupTags][ccon]DataSource.NotFound: Excel Workbook: [ccon]The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. The 64-bit version of the Access Database Engine OLEDB provider may be required to read this type of file. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987.[/ccon]. [/ccon]. The exception was raised by the IDbCommand interface. Table: MarlinnDailyOpenPO.
Cluster URI: WABI-US-NORTH-CENTRAL-H-PRIMARY-redirect.analysis.windows.net
Activity ID: 8b147179-3067-4789-a2b2-c4c2133e30d9
Request ID: f9996d1b-360a-78d8-e376-d72e53944561
Time: 2023-11-28 14:38:19Zold post but did you ever get this figured out?
- TheoC
Hi Tmk123
I'm sorry it didn't work. These things can be quite challenging to get right but, hopefully, we'll get there, my friend.
Can you do me a favour and check out: https://learn.microsoft.com/en-us/answers/questions/1319599/how-to-fix-the-microsoft-ace-oledb-12-0-provider-i
I'm hoping that this approach may assist? And you are certainly not the only person using XLS, I can assure you!
Theo
I am currently having same issue, any luck on this Tmk123 ?? - got everything how I wanted it pulling in xls file from a sharepoint folder using pbi desktop, utilized query editor to do appropriate transforms. Published to pbi web service and experiencing same error as you when trying to refresh the dataset on web service. So close, but another roadblock in leveraging data from xls file.
What local machine is it even referring to in the error message? I too am stumped on this
So I was having same issue - figured out what needed to be done to resolve this issue in my case. If you have a PBI data gateway available to utilize for reports published to web (my company has a gateway to connect to on-prem data sources), you need to to install Access Database Engine Redistributable: https://www.microsoft.com/en-us/download/details.aspx?id=54920 on the same server/machine that's hosting your gateway.
When you connect your published report to the gateway (in my case I'm using web connection to .xls file stored in onedrive location, using power automate to keep said .xls up to date in onedrive), you need to add your pbi report data connection, even if it's cloud based, to your data gateway. This way your PBI report is able to leverage the Access Database Engine Redistributable file on the machine your gateway is installed on during scheduled refreshes.
In screenshot, highlighted the important part, .xls files use the access db engine when being loaded into PBI. https://learn.microsoft.com/en-us/power-query/connectors/access-database#import-access-database-to-power-bi-desktop
