connecting to sharepoint sub folder

[Anonymous]

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

[Controla]

Connect to SharePoint as usual, then in the formula bar in the query editor change SharePoint.Files to SharePoint.Contents 

This will change the pulled data view to a table allowing you to click into the word "table" on the left of the rows of data so you can navigate to the relevant directory then draw down on the data. 

You can also do this for parent folders with subdirectories.

[Edson_Cruz94]

I have the same problem... looking for any option to solve that.

[TomMartens]

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

[Anonymous]

Hi Tom

I am having the same probleme as Jerome (and probably as many other people). I fi get this right, you are saying that one can only connect to the root SharePoint folder? If this is the case, i don't see the value of connecting Power BI to Sharepoint as:

1. The files organisation becomes a mess

2. As Power BI only loads 1000 files, there is very little probability that we will be able to find the files we need in this subset.

Am I missing something? If yes, can you give us guidance on how to connect Power BI with files on a Sharepoint subfolder?

Many thanks

Daniel

[Noivilbo]

+1 on this , we have exactly the same issue. There must be a stable/efficient way to connect PBI to sharepoint, given both are microsoft?

FYI for OP - workaround that I'm using, is creating a new sharepoint library, which only contains a limited number of files that need to connect to powerBI. And for you, worst case, you could make a microsoft automate worklow that copies the files in certain folders from your current sharepoint library to the new one overnight?

[Chrisjm15]

Can't believe this still isn't possible.

We're all using cloud now rather than local servers for data storage.

They're both Microsoft products.

Just speak to the guys down the hall and sort it!

[RichardTam]

I understand your pain, it sounds absolutely ludicrous, broderline imcompotent on Microsoft's part that their products are poorly optmised. Combining the way Power Query Editor handles query editing & preview, it is almost impossible to work on anything, in fact, I am waiting for it to load as I'm typing

[Anonymous]

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?