Sharepoint Folder: "Access to the resource is forbidden."

[UsePowerBI]

Hello

I add a sharepoint folder https://domain.com/sites/AWRPA0433/

I can access this via web but PowerBI says "Access to the resource is forbidden."

Any idea?

[trebgatte]

I created this blog post with video for a similar question. https://marqueeinsights.com/how-to-merge-multiple-excel-files-with-power-bi/ This shows you the steps to get connected. 

Hope this helps!

--Treb, Power BI MVP

[dax · Accepted solution]

Hi @UsePowerBI , 

You could refer to my post for details. In addition, you also need to click Edit Queries->Datasoure Setting to delete your orginal credential on sharepoint, then re-connect it and make sure your credential is correct and have permission to access foler.

Best Regards,
Zoe Zhi

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

[prakash11440278]

Hi @UsePowerBI ,

To connect to SharePoint folder, the specified URL should be site URL which is similar to:

https://microsoft.sharepoint.com/teams/sitename

If your site is Office365, please enter Microsoft Account using windows credentails.

[mwegener]

Hi @UsePowerBI 

are other credentials for the connection stored in the Power BI Desktop?

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.