Forum Discussion

CupidC's avatar
CupidC
Helper II
2 years ago
Solved

Accessing Public Shared Point Folder

Hi Everyone, I have a question regarding the integration of a public share point folder into our Power BI.   We are trying to access a publicly available stocklist from one of our suppliers, which...
Dataflow
Need Help
  • christinepayton's avatar
    christinepayton
    2 years ago

    You need to use authentication with SharePoint sources for Power BI. The "public" access sharing is via sharing link, which won't work in the SharePoint connectors. What I would do is have the organization "share" access to the content with your Microsoft account explicitly via granting actual permission on the files or site (preferably the site). If you can get added as a site member, that would be more foolproof. I just tested this with my external account on my tenant and it worked (I wasn't sure if it'd work for external users - looks like it does!). 

     

    Then you need the site URL or actual file path to connect (depending on the connector you're using), which will be a little bit of a different format from the one you have now. It won't have the :f/s in it, it usually has a format like https://rootname.sharepoint.com/sites/sitename instead.

     

     

collinq's avatar
collinq
Super User
2 years ago

Hi CupidC ,

 

I was able to go to the web and see this document online without issue.  However, this appears to be a "view only" file.  I tried with both "Web" and "SharePoint Folder" data connections and got the sign on permissions issue with both types.

 

I am wondering if you can either:

1. Get a userid and password and then put that into a gateway 

OR

2. Have the sender modify the permissions on the file to allow you to "edit"