Unable to get data into Power Bi desktop from MS Access DB which is in SharePoint

[HaveeshPerla_1]

Hi All,

I'm trying to get data from the MS Access which is located in SharePoint. I tried connecting through Web link but getting as inappropriate path for the correct one. Also tried using Sharepoint categories but encountering error. Please help me to figure this out. 

[v-yiruan-msft]

Hi @HaveeshPerla_1 ,

Do you get any error messages when connect to MS Access in Power BI Desktop? If so, could you please share it with us? Later we can make a troubleshooting to find out the cause and check whether we can resolve it...

In addition, please refer the following links to connect to MS Access using SharePoint online list connector and check whether if can connect to MS Access successfully:

PBI Service refresh from MSAccess on SharePoint?

Use SharePoint Online List As A Data Source In Power BI

Best Regards

[lbendlin]

While you might be able to make this work via the local endpoint for that OneDrive (when you sync the Sharepoint folder)  this sounds like a rather unfortunate choice of location for the Access database. What was your reason for doing that?