Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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. ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
Noivilbo
Frequent Visitor
6 years ago

+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?