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?
Could you just install the Access Database Engine download that was mentioned in the help?
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.
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.