Forum Discussion
connecting to sharepoint sub folder
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
+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?
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!
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
