cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JeromeC Frequent Visitor
Frequent Visitor

connecting to sharepoint sub folder

Hi Team,

I have a sharepoint site, lets call it ABC. within it I have over 100 subfolders, and i would only like to access one sub folder called "data test" when connecting to PowerBI Desktop.

the site  url itself is  https://.sharepoint.com/sites/ABC  

Since PBI desktop only lets you put the the site URL, when i load the site url, i have over 1000 of files, and cannot filter to that particular sub folder. 

Is there a way to easily connect to one sharepoint subfolder? Any help would be appreciated. 

Jerome

2 REPLIES 2
Super User
Super User

Re: connecting to sharepoint sub folder

Hey,

unfortunately this not possible.

You have to use the path field to use text filter that specifies your subfolder.

Wondering why you can't filter, because of the amount of the files?

Regards,
Tom
Hamburg - Germany
If I answer you question, please mark my post as solution, this will also help others.
Proud to be a Datanaut!
JeromeC Frequent Visitor
Frequent Visitor

Re: connecting to sharepoint sub folder

Hi Tom,

 

Yes, there are too many files in that site, so it only lets me filter to the first 1000. 

I am trying to reach site/ABC/x/x/x/x/data test/ 

within that, is 4 excel files. the goal is to add files each month so i can refresh it easily.

it seems that the only way is to have a local file path and refresh it on 1 computer? 

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 282 members 2,946 guests
Please welcome our newest community members: