Forum Discussion

Hashir786's avatar
Hashir786
Regular Visitor
3 years ago

Refresh Error on Power BI Web

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...
Dataflow
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 Center

 

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's avatar
Hashir786
Regular Visitor
3 years ago

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.