Connecting to Sharepoint Online

[PA7177]

I am trying to connect to some folders and keep getting this error.

I checked the data source settings and have signed in through my Microsoft account, my organizational account, and my Windows account. 

Any ideas?

[PA7177 · Accepted solution]

Hi everyone,

I was able to solve the issue by clearing ALL global data source credentials.

[Icey]

Hi @PA7177 ,

I have tested on my side and it works well.

Please do the following steps:

1. Update the Power BI desktop to the latest version.
2. Ensure that the account you are using to authenticate on Power BI Desktop has full access to the SharePoint data source and the file location/Permission has not change in SharePoint.
3. On your Computer go to the following path: C:\Users\ yourusername\AppData\ Local\Microsoft\Power BI Desktop and rename the Zip folder User.zip to User1.zip. This will clear all previous user logins caches and will create a new user folder.
4. On Power BI Desktop edit the Data source Credentials: From Home >> Edit Queries >> Data source Settings >> Edit Permissions >>Edit >> Sign in as different User (With the account you used to access the SharePoint Site) Save and close.

Best Regards,

Icey

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

[parry2k]

@PA7177 hope this link helps

[PA7177]

Thanks Parry but I still end up with the same error even when following the required format for Sharepoint Folder 

https://[myorganization].onmicrosoft.com/sites/[Your Site Name]/

There is also the difference of my root url containing "sharepoint.com" rather than "onmicrosoft.com"

I tried both formats and still get the unable to connect screen telling me that "Access to the resource is forbidden."