Forum Discussion
Connecting to a SharePoint SubFolder without Root Directory Permission
Hi Sorry for the slow reply v-piga-msft and thank you for responding. It seems I didn't explain my problem well enough. The link you provided appears to just go through the standard sharepoint connection using the parent location, which is not a problem.
Our SharePoint has folders such as:
https://xxx.sharepoint.com/sites/wholecompany/TeamA
https://xxx.sharepoint.com/sites/wholecompany/TeamB
https://xxx.sharepoint.com/sites/wholecompany/Financial
In SharePoint - my colleague has access to the TeamA subdirectory, but not to the wholecompany parent location. Since Power BI asks for the parent location - does this mean that PowerBI cannot access these files? even though she does have access to the subdirectory?
I hope i have explained it a little better this time. Thank you!
It's been a while with no response - still looking for anyone who knows if this is possible or not :)
Im having the same problem. Any ideas anyone?!!!
v-piga-msft
Same issue here, any idea how to connect to a subfolder with the "Sharepoint Folder" Connector, when you have no rights to the root folder of Sharepoint?
I also need to combine all the data in the folder, using the web connector this will not workAnonymous Anonymous Found anything yourselves?
Kind regards
Jasper BaertJust saw this after like a year, sorry haha
My solution has been to use Power Automate to replicate the files into another location which can be accessed. This way even if the power bi user has no access at all, you can set up a flow running from a different persons account who does have access, and then run the power bi like normal.
It would be better if it was possible to connect to a specific location but this is the current work around as far as I know.
I don't consider this solved so I'm leaving this thread open until we do get a proper solution.
