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

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