Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

0

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

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. 

 

Got the below error while I was trying with all "Sharepoint" categories where the given url is correct one.

HaveeshPerla_1_0-1647511722701.png

 

Status: Delivered

Hi @Anonymous ,

 

If you would like to connect to the accdb file on SharePoint site, please try this solution.

1 Get the site URL from SharePoint

vcazhengmsft_0-1648100608635.png

 

2 Connect to data source with SharePoint folder connector and provide correct credential

vcazhengmsft_1-1648100608637.png

 

vcazhengmsft_2-1648100608639.png

 

vcazhengmsft_3-1648100608640.png

 

Then, you will see the data from Accdb file displayed in Desktop.

vcazhengmsft_4-1648100608641.png

 

Best Regards,

Community Support Team _ Caiyun

Comments
v-cazheng-msft
Community Support
Status changed to: Delivered

Hi @Anonymous ,

 

If you would like to connect to the accdb file on SharePoint site, please try this solution.

1 Get the site URL from SharePoint

vcazhengmsft_0-1648100608635.png

 

2 Connect to data source with SharePoint folder connector and provide correct credential

vcazhengmsft_1-1648100608637.png

 

vcazhengmsft_2-1648100608639.png

 

vcazhengmsft_3-1648100608640.png

 

Then, you will see the data from Accdb file displayed in Desktop.

vcazhengmsft_4-1648100608641.png

 

Best Regards,

Community Support Team _ Caiyun