cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
andrewbrick Regular Visitor
Regular Visitor

Scheduled refresh from Access: 64-bit Windows, 32-bit Office, 32-bit Power BI

I'm running 64-bit Windows.  I built a report in 32-bit Power BI (desktop) with a data source from an Access database (32-bit).  The connection works great in desktop.  I've pushed it to the cloud, and I've successfully added the Access database as a data source in the on-prem gateway (Power BI says "Connection Successful").  When I attempt to refresh from the cloud, I get the following error:

 

Microsoft Access: 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 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.

 

I can't install the 64-bit version because I have 32-bit Office installed.  Is there a solution?

4 REPLIES 4
Super User
Super User

Re: Scheduled refresh from Access: 64-bit Windows, 32-bit Office, 32-bit Power BI

Could you just install the Access Database Engine download that was mentioned in the help?

 

https://www.microsoft.com/en-us/download/details.aspx?id=13255


   

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

Proud to be a Datanaut!


   


andrewbrick Regular Visitor
Regular Visitor

Re: Scheduled refresh from Access: 64-bit Windows, 32-bit Office, 32-bit Power BI

The installer gave me an error and wouldn't proceed because I had 32-bit office products installed.  I've since uninstalled old products, leaving only Office365.  I uninstalled the 32-bit Access Database Engine and was then able to install the 64-bit version.  A few quick new DSNs in the ODBC manager, and I was up and running.

I believe BI could be enhanced by giving users the option of which bitness to use across all products.  What seemed to cause the error is that I'd done everything in 32-bit, but the cloud version defaults to 64-bit (or perhaps whatever the bitness of your Windows install is).  The primary reason I was using 32-bit was because my data source is R, using a RODBC connection.  I'd previously only been able to use RODBC with the 32-bit version of R, but it appears it works with the 64-bit version now.  (Additionally, when using R in Power BI, I had to move the 64-bit version of R to a place Power BI couldn't find it, because it defaults to using the 64-bit version of R, and there is no option in BI to tell it to use the 32-bit version of R.)

 

So, I've been able to work around my problem by switching everything over to 64-bit, but I think the bitness thing still exists as an issue.

Moderator v-yuezhe-msft
Moderator

Re: Scheduled refresh from Access: 64-bit Windows, 32-bit Office, 32-bit Power BI


Hi @andrewbrick,

Power BI Service can only leverage 64 bit drivers, please use 64 bit access instead, and you should have no issues refreshing 64 bit Access database in Power BI.  There is an similar thread for your reference.

 

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
andrewbrick Regular Visitor
Regular Visitor

Re: Scheduled refresh from Access: 64-bit Windows, 32-bit Office, 32-bit Power BI

Thanks!