Forum Discussion
Unable to refresh in PowerBI Service through Local Gateway.
Hi,
I am unable to refresh my data connection in PowerBI Service through the Local Gateway.
However I am succesful in doing so through my local PowerBI desktop, with Access, PowerBI and Database Engine all in 32bit version. Any suggestions?
Underlying error code: -2147467259
Underlying error message: 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 OLEDB provider may be required to read 'General Ledger.accdb'. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987.
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.Reason: DataSource.NotFound
Cluster URI: WABI-NORTH-EUROPE-redirect.analysis.windows.net
Activity ID: e783ef72-1543-470a-b523-8056745f731d
Request ID: f7d41327-b9be-3bb4-2c92-9fde308fb195
Time: 2021-08-09 10:08:23Z
3 Replies
- lbendlin
Super User
The gateway doesn't speak 32 bit. As indicated you need to install the 64 bit access engine on the gateway.
You may want to switch to 64 bit mode throughout.
- arvindsingh802
Community Champion
as mentioned by lbendlin you have to install 64 bit of all (Power BI Desktop, Access Database, Access database connector) to resolve this issue.
Also if your gateway is hosted in different machine you have to install 64 bit access database connector on that machine
Download Microsoft Access Database Engine 2010 Redistributable from Official Microsoft Download CenterIf this post helps, then please consider Accept it as the solution and give it a thumbs up
