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