cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
James1965 Regular Visitor
Regular Visitor

Re: My coworker has not access to shared folder at my SharePoint online

Hi all,

 

My conclusion is then that Power BI could not access dataset on shared SharePoint folder.

 

Thank you for your attension!

Moderator v-yuezhe-msft
Moderator

Re: My coworker has not access to shared folder at my SharePoint online

@James1965,

What connector do you use in Power BI Desktop, sharepoint folder or web?

I use web connector to connect to an excel file of a sharepoint online folder in the Desktop, create report. Then share the sharepoint folder to my colleague and send the PBIX file to her, she can refresh data in the PBIX file after enter her credential for the data source. 

However, if you create report using SharePoint Folder connector in Power BI Desktop, it is not possible for your colleague to refresh the PBIX file as it requires the colleague to have permission on the root SharePoint site, but the colleague only have permission on the folder but not the root site.  When using web connector, the issue doesn't occur because we can choose URL of the Excel file URL in "Select which level to apply these settings to" dropdown, and the colleague has sufficient permission on this level.
Capture.PNG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
James1965 Regular Visitor
Regular Visitor

Re: My coworker has not access to shared folder at my SharePoint online

Hi Lydia,

Thank you very much! This is the point. One have then two options to do it,

 1. I can place the dataset on the root and share the root to my coworker. I could not find way to share the root. How could I share the root to other?

 2. To use Web-connecter. How could I get the URL of the data file under a folder (in my SharePoint)?

 

I have tried above two options wothout seccess.

 

Best regards

James.

Moderator v-yuezhe-msft
Moderator

Re: My coworker has not access to shared folder at my SharePoint online

@James1965,

1. Please review this article.
2. the URL is : https://XXXX.sharepoint.com/sites/Yoursitename/Shared%20Documents/YourFolder/Yourfilename.xlsx.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
James1965 Regular Visitor
Regular Visitor

Re: My coworker has not access to shared folder at my SharePoint online

Hi Lydia,

It does not work for my coworker - with Web-connecter. Error massage is as below. It added "/_api/contextinfor" to the original adress.

 

best regards/ James

Untitled.jpg

Moderator v-yuezhe-msft
Moderator

Re: My coworker has not access to shared folder at my SharePoint online

@James1965,

What level do you choose when using web connector? Do you in same domain with your cowoker?

Capture.PNG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
James1965 Regular Visitor
Regular Visitor

Re: My coworker has not access to shared folder at my SharePoint online

Hi Lydia,

I don´t know what you mean with "level". I get the dataset through ->Get data ->Web and give the URL.

My coworker is in the same domain as me - the same organisation, regarding MS counter. The SharePoint folder, which is stand along, is merely shared to my coworker.

 

Best regards/ James

Moderator v-yuezhe-msft
Moderator

Re: My coworker has not access to shared folder at my SharePoint online

@James1965,

When you use web connector, and click the drop-down in the above highlighted textbox, do you select the URL of your file?

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
James1965 Regular Visitor
Regular Visitor

Re: My coworker has not access to shared folder at my SharePoint online

Hi Lydia,

I use, ->Get Data ->Web and give the URL as

 

 Source = Csv.Document(Web.Contents("https://geoteknik.sharepoint.com/sites/NCGeoteknik/Delade%20dokument/Prjket1/18-Selma.txt"),[Delimit...",", Columns=8, Encoding=1252, QuoteStyle=QuoteStyle.None]),
 

It works for me, but not for my cowork - credential controll.

 

Regards/ James

Moderator v-yuezhe-msft
Moderator

Re: My coworker has not access to shared folder at my SharePoint online

@James1965,


Everything works well in my scenario. Please make sure your coworker choose organizational account and select last level(file level) when signing in SharePoint.
1.PNG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

Top Ideas
Users Online
Currently online: 397 members 3,845 guests
Please welcome our newest community members: