Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Connecting to a SharePoint SubFolder without Root Directory Permission

So I have used SharePoint Folder connectivity a fair bit, and have successfully connected to the typical format of: https://company.sharepoint.com/sites/myworkspacename From there I navigate to sub...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

It's been a while with no response - still looking for anyone who knows if this is possible or not :)

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Im having the same problem. Any ideas anyone?!!!

  • JasperBaert's avatar
    JasperBaert
    Helper I
    5 years ago

    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 work

    Anonymous Anonymous  Found anything yourselves?

     

    Kind regards
    Jasper Baert

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Just 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.