unable to connect sharepoint folder from powerbi desktop

[Anonymous]

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. 

[AllisonKennedy · Accepted solution]

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.

[mwegener · Accepted solution]

Hi @Anonymous ,

@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/

[Icey]

Hi @Anonymous ,

Please let us know if the methods above are helpful. 

Best Regards,

Icey

[mwegener · Accepted solution]

Hi @Anonymous ,

@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/

[Anonymous]

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 ?

[Icey · Accepted solution]

Hi @Anonymous ,

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.

[AllisonKennedy · Accepted solution]

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.