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

Connecting a SharePoint List with OData feed worked for some users

by Matthew Adams
Matthew Adams
Matthew Adams
Windows & Software Expert
Matthew is a freelancer who has produced a variety of articles on various topics related to technology. His main focus is the Windows OS and all the things... read more
Reviewed by Alex Serban
Alex Serban
Alex Serban
Windows Server & Networking Expert
After moving away from the corporate work-style, Alex has found rewards in a lifestyle of constant analysis, team coordination and pestering his colleagues. Holding an MCSA Windows Server... read more
Affiliate Disclosure
  • 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

To fix various PC problems, we recommend Restoro PC Repair Tool:
This software will repair common computer errors, protect you from file loss, malware, hardware failure and optimize your PC for maximum performance. Fix PC issues and remove viruses now in 3 easy steps:

  1. Download Restoro PC Repair Tool that comes with Patented Technologies (patent available here).
  2. Click Start Scan to find Windows issues that could be causing PC problems.
  3. Click Repair All to fix issues affecting your computer's security and performance
  • Restoro has been downloaded by 0 readers this month.

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.