cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Get Data - SharePoint folder

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Get Data - SharePoint folder

Hi @PetyrBaelish ,

 

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.

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Get Data - SharePoint folder

Hi @PetyrBaelish ,

 

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.

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

Re: Get Data - SharePoint folder

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.

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)