Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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. 

  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi Anonymous 

     

    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... .

1 Reply

  • v-diye-msft's avatar
    v-diye-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous 

     

    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... .