Are you stucking with the “Access to the resource is forbidden” error in Power BI, especially when trying to connect to a SharePoint Online list?
In this Power BI article, I will tell you how to fix the access to the resource is forbidden error in Power BI.
Power BI Error: Access to the Resource is Forbidden
When I try to connect the SharePoint online site to Power BI, this type of error occurs, like “Unable to connect: Access to the resource is forbidden.” Check the screenshot below.
The above error in Power BI typically occurs when the user does not have the necessary permissions to access the requested resource.
Power BI Access to the Resource is Forbidden [Solved]
Now, we see how to fix the expression. Error: access to the resource is forbidden in Power BI.
1. Open Power BI Desktop. Then, click on the “File” tab located at the top left corner of Power BI.
2. Then, click Options and settings on the menu. Select the Data source settings.
3. Select the site URL and click “Edit Permission” on the Data source settings page.
4. Then, an Edit Permissions pop-up comes here. Click the Edit button.
5. Sign in with your account Using the “Sign in” option.
6. After Signing in to your account, you can see that no error is coming when I try to give the site URL to get data.
This way, you can fix access to the resource is forbidden Error in Power BI.
When you try to connect, Ensure that your user account to connect to the SharePoint list has the necessary permissions to access the list data.
Also, you may like:
- Power BI Error: Contact your admin to enable embed code creation
- How to Solve NaN Error in Power BI
- Power BI Error: This content isn’t available
I am Bijay a Microsoft MVP (10 times – My MVP Profile) in SharePoint and have more than 17 years of expertise in SharePoint Online Office 365, SharePoint subscription edition, and SharePoint 2019/2016/2013. Currently working in my own venture TSInfo Technologies a SharePoint development, consulting, and training company. I also run the popular SharePoint website EnjoySharePoint.com
Thanks a lot. The above mentioned resolution perfectly worked for me while troubleshooting same issue.
Thank you and I am glad it worked for you. Like our Facebook page for more updates also https://www.facebook.com/LearnMicrosoft365
Hi, I still having this issue after following the steps shown
Thank you Bijay for such a nice explanation with step by step process and the most valuable part is explanation along screenshots
Thanks for your kind words Vivek!
Hi am facing the same issue while trying to connect Google Analytics to Power BI. The above steps are not helping, can you please guide me? Thanks!
This is a life saver, thank you si much
Thank you.. It works