Forum Discussion
Getting Access Forbidden Error While Connecting Power BI with SharePoint Online Root folder
Hey Anonymous ,
i have encountered this problem quite often, if I tried to access content within Sharepoint online, what helped me was doing this:
- From within the Power BI Desktop open the pbix that you want to access Sharepoint content
- Goto File --> Options and settings --> Data source settings
Delete all existing permissions that point to Sharepoint and contain the site name, do this for the "Data sources in the current file" and also for the "Global permissions".
Just hit refresh, if asked for your credentials make sure you choose "Organizational Account" do not choose "Windows". This at least is valid for resolving connections problems to "Sharepoint online".
Hopefully this helps to solve your issue.
Regards,
Tom
Hey Anonymous ,
i have encountered this problem quite often, if I tried to access content within Sharepoint online, what helped me was doing this:
- From within the Power BI Desktop open the pbix that you want to access Sharepoint content
- Goto File --> Options and settings --> Data source settings
Delete all existing permissions that point to Sharepoint and contain the site name, do this for the "Data sources in the current file" and also for the "Global permissions".
Just hit refresh, if asked for your credentials make sure you choose "Organizational Account" do not choose "Windows". This at least is valid for resolving connections problems to "Sharepoint online".
Hopefully this helps to solve your issue.
Regards,
Tom