cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

unable to connect sharepoint folder from powerbi desktop

Team,

I am unable to connect sharepoint folder / sharepoint online lists from powerbi desktop. I am currently using power bi pro july edition. i set the credential as organisation in data source settings for sharepoint kindly help on this. So that i can setup auto refresh using flow / api call. PFA of errors which am facing. FYI I am having owner permission for OSDOperation in teams. 

gshastri_0-1596250333580.png

 

2020-08-01_8-23-12.png

 

3 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Community Champion
Community Champion

Re: unable to connect sharepoint folder from powerbi desktop

Click Edit on the Credentials window and change from 'Windows' to 'Organizational Account'.

Then make sure you are logged in to Power BI desktop with the same username and password as you have owner access for in Teams.

 


______________


Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved. 


If you found this post helpful, please give Kudos.


I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query. 


https://sites.google.com/site/allisonkennedycv

View solution in original post

Highlighted
Super User III
Super User III

Re: unable to connect sharepoint folder from powerbi desktop

Hi @gshastri ,

 

@AllisonKennedy is right you have to use the Organization Account connection method.

In your screenshot you only change the privacy level of the data.

 

I think the next problem will be the correct URL of the SharePoint site.

 

Here you will find an illustrated guide.

https://powerbi.tips/2016/09/loading-excel-files-from-sharepoint/

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

I work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #BetterTogether
twitter - LinkedIn - YouTube - website

View solution in original post

Highlighted
Community Support
Community Support

Re: unable to connect sharepoint folder from powerbi desktop

Hi @gshastri ,

 

Based on my test, it does not have to be the owner of the folder. Just need to have read permission.

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
Highlighted
Community Champion
Community Champion

Re: unable to connect sharepoint folder from powerbi desktop

Click Edit on the Credentials window and change from 'Windows' to 'Organizational Account'.

Then make sure you are logged in to Power BI desktop with the same username and password as you have owner access for in Teams.

 


______________


Has this post solved your problem? Please mark it as a solution so that others can find it quickly and to let the community know your problem has been solved. 


If you found this post helpful, please give Kudos.


I work as a trainer and consultant for Microsoft 365, specialising in Power BI and Power Query. 


https://sites.google.com/site/allisonkennedycv

View solution in original post

Highlighted
Super User III
Super User III

Re: unable to connect sharepoint folder from powerbi desktop

Hi @gshastri ,

 

@AllisonKennedy is right you have to use the Organization Account connection method.

In your screenshot you only change the privacy level of the data.

 

I think the next problem will be the correct URL of the SharePoint site.

 

Here you will find an illustrated guide.

https://powerbi.tips/2016/09/loading-excel-files-from-sharepoint/

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

I work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #BetterTogether
twitter - LinkedIn - YouTube - website

View solution in original post

Highlighted
Community Support
Community Support

Re: unable to connect sharepoint folder from powerbi desktop

Hi @gshastri ,

 

Please let us know if the methods above are helpful. 

 

 

Best Regards,

Icey

 

Highlighted
Helper I
Helper I

Re: unable to connect sharepoint folder from powerbi desktop

Thanks mate, I succeed - login to SharePoint folder through PowerBI.

To access SharePoint folder/list, and to create flow for automate is it mandatory to being Owner of that folder ?

 

Highlighted
Community Support
Community Support

Re: unable to connect sharepoint folder from powerbi desktop

Hi @gshastri ,

 

Based on my test, it does not have to be the owner of the folder. Just need to have read permission.

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors