FIX: Power BI not connecting to SharePoint List [Guide]

Connecting a SharePoint List with OData feed worked for some users

Reading time icon 3 min. read

Readers help support Windows Report. We may get a commission if you buy through our links. Tooltip Icon

Read our disclosure page to find out how can you help Windows Report sustain the editorial team Read more

Key notes

  • Some Power BI users have reported issues connecting to SharePoint lists, with errors such as "URL isn't valid" or "Access to resource forbidden" appearing.
  • Possible solutions include entering Microsoft account credentials for the SharePoint list, clearing the list's permissions, or trying to connect the list with an OData feed.
Windows Media Player cannot open audio and video files

Power BI Desktop is software with which users set up charts and interactive visualizations for connected data sources. SharePoint lists are data sources users can connect to Power BI with.

However, some users have stated in forum posts that they can’t connect Power BI with their SharePoint lists. The URL isn’t valid or Access to resource forbidden are two errors that arise for some BI users when they try to connect SharePoint lists.

First, double-check the SharePoint list’s URL entered in the URL text box when a “URL isn’t valid” error arises. Users need to specify SharePoint sites as follows: https://<companyname> Make sure that the URL entered doesn’t include any typos.

Power Bi unable to connect to a SharePoint Online list

1. Enter Microsoft Account Credentials for SharePoint List

  1. Some users have fixed “URL isn’t valid” connection errors for SharePoint lists by editing the data sources’ permissions so that they include Microsoft account credentials. To do that, click the File tab in Power BI Desktop.
  2. Select Options and settings > Data Source Settings to open a Data source settings window.
  3. Select the SharePoint list in that window.
  4. Click Edit Permissions to open an Edit Permissions window.Edit Permissions window power bi won't connect to sharepoint list
  5. Click Edit to enter Microsoft account credentials.
  6. Then press the OK button.

2. Clear the SharePoint List’s Permissions

  1. Clearing permissions for SharePoint list data sources can resolve “Access to resource forbidden” connection errors. Users can do that by opening the Data source settings window as outlined above.Data source settings power bi won't connect to sharepoint list
  2. Then select the Global Permissions option.
  3. Select the SharePoint list listed within the window.
  4. Press the Clear Permissions button.
  5. Select the Close option.
  6. Then users can re-enter the credentials for the SharePoint list.

3. Try Connecting a SharePoint List With OData Feed

  1. Alternatively, users can try connecting their SharePoint lists with OData feed when they can’t connect them via the Get Data dialog window. Press the Get Data button on Power BI’s Home tab.
  2. Click OData Feed to open the window shown directly below.OData Feed window power bi won't connect to sharepoint list
  3. Enter the SharePoint list URL feed in the text box with the following format: http: //SITE_URL/_vti_bin/ListData.svc.
  4. Select an authentication method for the SharePoint list data source.
  5. Click the Connect button.

Those are a few resolutions that might resolve Power BI connection errors for SharePoint lists. For additional resolutions that might fix SharePoint list connection errors, check out the Power BI support website. Users can send Power BI support tickets by clicking the Create Support Ticket button on that site.


More about the topics: Sharepoint issues