Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Error accessing SharePoint List from Power BI Desktop: "Access to the resource is forbidden."

Hello all,

 

I am trying to import data from a SharePoint list and I'm getting the following error:

 

image.pngI've made sure the URL is the root one, I've made sure I'm logged in to my Power BI account which has a license, I've made sure the SharePoint list is accessible to me as I'm the owner of it, I've tried importing the data from a different computer with a different account and it still didn't work.

 

Is there anything else I should try?

 

Thank you.

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

I've had a colleague help me fix it. The way I did it was go into Power BI Desktop version>File>Options and settings>Data source settings. See image below

 

image.png

 

There I chose "Edit Permissions" and opened up a new window:

 


image.png

I pressed "Edit" and then selected the bottom option in the left side to connect with my organization credentials. Before I used the Anonymous option to connect and seems like that was the issue. 

 


image.png

The login is not the same for me after I connected but it should look similar to this. Thought I'd post this for future reference.

View solution in original post

1 REPLY 1
Anonymous
Not applicable

I've had a colleague help me fix it. The way I did it was go into Power BI Desktop version>File>Options and settings>Data source settings. See image below

 

image.png

 

There I chose "Edit Permissions" and opened up a new window:

 


image.png

I pressed "Edit" and then selected the bottom option in the left side to connect with my organization credentials. Before I used the Anonymous option to connect and seems like that was the issue. 

 


image.png

The login is not the same for me after I connected but it should look similar to this. Thought I'd post this for future reference.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors