Get Data - SharePoint folder

[Anonymous]

I have a SharePoint Online site used to store 'ad hoc' data sources - basically a place to store csv files and excel spreadsheets. I use SharePoint premissions to control access.

The site is set up to use multiple document libraries, as such:

Doc Library A - stores HR csv data, accessible to users A-G

DOc Library B - stores Finance csv data, accessible to users F-M

Doc Library C - stores ICT csv data, accessible to users J-P

The csv files in each library are of an identical format and a new csv file is generated every week and the data naturally appends.

I first set this up when only Doc Library A existed In Power BI I get the data by the "SharePoint folder" option and combine the data for everything in Doc Library A. It works perfectly.

Now I'm attempting to repeat the process for Doc Library B, but when I select Get Data - SharePoint Folder and put in the URL of the site, it's brining back data from all 3 document libraries (I have permission to see them all -and many of the users can see multiple libraries). How can I restrict this to just a single library without having to manually filter bits out?

Is it the case that Power BI can only see a site as the most granular logical container? That doesn't make sense as Power BI and SharePoint are both MIcrosoft Office 365 products. My SharePoint structure isn't set up in a way whereby I'd separate the libraries into different sites, I need Power BI to get data just from a document library, is this possible?

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

I am afraid that you are not able to directly connect to SharePoint Form Library in Power BI Desktop, an idea about this issue has been submitted in this link, please vote it up.

In your scenario, as a workaround, push data to Excel firstly and then connect to the Excel file in Power BI Desktop.

[Anonymous]

Thanks for your response,

When connecting to my data using SharePoint folder I'm able to filter it based on the folder path - it's OK as there's only 3 libraries in use but this isn't great should I be working on a site with 50+ libraries.

Just to confirm I was referring to SharPoint document libraries rather than form libraries (as mentioned in the link your provide) - although from what I can gather that doesn't actually make a difference.