cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Radhikaa Visitor
Visitor

Missing columns when connecting data using Sharepoint Online List

I am trying to pull data from MS Project (Professional Online) which is available on my sharepoint website, using Sharepoint Online List. When I do so, only the default columns get pulled through and the custom columns that I have created do not come through.

 

I have tried the solution suggested here but it does not work for me. It keeps giving me an error saying "Access to the resource is forbidden". 

 

Any help on this is appreciated. 

Thanks in advance. 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: Missing columns when connecting data using Sharepoint Online List

Hi @Radhikaa 

 

when you encounter the error : "Access to the resource is forbidden", please follow below steps:

In the Power BI desktop Click on “Edit Queries” from the ribbon then select on “Data source settings”.

power bi access to the resource is forbidden

Select on the site URL then click on “Edit Permission” in the Data source settings page.

power bi access to the resource is forbidden

Click on Edit.

power bi access to the resource is forbidden

Select on Organizational account then click on Sign in.

access to the resource is forbidden power bi

Pick an account. And double click on it.

power bi access to the resource is forbidden

Now when I am trying to give the site URL in getting data no error is coming. In the Navigator page, all the site list are coming.

power bi access to the resource is forbidden

Please note that:

If your site is Office365, please enter organizational credential using the third option in the above screenshot. If your site is on premise, use Windows credentials as you mentioned. In addition, make sure that you use the latest version of Power BI Desktop.

For more details about connecting to SharePoint Online list from Power BI Desktop, please review this similar article: https://support.office.com/en-us/article/Connect-to-a-SharePoint-List-Power-Query-3226f248-f8b3-4777... .

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

1 REPLY 1
Community Support
Community Support

Re: Missing columns when connecting data using Sharepoint Online List

Hi @Radhikaa 

 

when you encounter the error : "Access to the resource is forbidden", please follow below steps:

In the Power BI desktop Click on “Edit Queries” from the ribbon then select on “Data source settings”.

power bi access to the resource is forbidden

Select on the site URL then click on “Edit Permission” in the Data source settings page.

power bi access to the resource is forbidden

Click on Edit.

power bi access to the resource is forbidden

Select on Organizational account then click on Sign in.

access to the resource is forbidden power bi

Pick an account. And double click on it.

power bi access to the resource is forbidden

Now when I am trying to give the site URL in getting data no error is coming. In the Navigator page, all the site list are coming.

power bi access to the resource is forbidden

Please note that:

If your site is Office365, please enter organizational credential using the third option in the above screenshot. If your site is on premise, use Windows credentials as you mentioned. In addition, make sure that you use the latest version of Power BI Desktop.

For more details about connecting to SharePoint Online list from Power BI Desktop, please review this similar article: https://support.office.com/en-us/article/Connect-to-a-SharePoint-List-Power-Query-3226f248-f8b3-4777... .

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors