Refresh Error on Power BI Web

[Hashir786]

Hi,

I've connected MS Access file with Power BI via Sharepoint Folder. It's working perfect in Desktop but when I'm Publishing it to Web Service its not refreshing the data due to below mentioned error. Please help to resolve the issue.

Data source error: DataSource.NotFound: <ccon>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 this type of file. To download the client software, visit the following site: https://go.microsoft.com/fwlink/?LinkID=285987.. </ccon>. The exception was raised by the IDbCommand interface. Table: Dashboard_Details.
Cluster URI: WABI-UK-SOUTH-redirect.analysis.windows.net
Activity ID: b9db76c0-bec8-412d-87df-0d164f3b9021
Request ID: 40408b98-b4f8-4f4d-852f-419ffc87eac9
Time: 2023-06-20 14:12:25Z

[Anonymous]

Hi @Hashir786 ,

If you're loading an Access database to Power BI Desktop, the versions of the Access Database Engine 2016 OLEDB provider and Power BI Desktop on that machine must match (that is, either 32-bit or 64-bit). If you do not install Access Database Engine, please install it firstly Download Microsoft Access Database Engine 2016 Redistributable from Official Microsoft Download Cent...

For more details, you can read related document: Power Query Access database connector - Power Query | Microsoft Learn , Power Query Access database connector - Power Query | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Hashir786]

Hi @Anonymous ,
I'm loading Access database to power bi from Sharepoint online drive via share point folder. I've already installed Access Database Engine 2016 OLEDB on my machine. But I need to configure from share point online because I don't want to use on prem gateway. In power bi desktop its working perfectly fine but its not refreshing data on web service. Where the connection is between Access database (Sharepoint folder) to power bi.

[Hashir786]

Can anyone please respond?