FIX: Power BI won’t connect to SharePoint list

2 minute read
Windows Media Player cannot open audio and video files

Home » Fix » FIX: Power BI won’t connect to SharePoint list

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 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>.sharepoint.com/xyz_Test/. 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.

This guide will make you a better Power BI user. Do check it out.


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.

RELATED ARTICLES TO CHECK OUT: 

Discussions

Next up

Scroll bar is missing in Chrome on Windows 10 [FIX]

Alexandru Voiculescu By: Alexandru Voiculescu
2 minute read

Google Chrome is the most popular browser out there. It is a reliable tool to surf the Internet and has many great features. However, nothing […]

Continue Reading

What to do when your Uplay achievements are not syncing

John Taylor avatar. By: John Taylor
2 minute read

Uplay is an amazing game distribution platform created by Ubisoft. It can be used to buy and download games as well as DLCs. It can […]

Continue Reading

FIX: Ubisoft server unavailable

John Taylor avatar. By: John Taylor
2 minute read

The market is filled with game distribution platforms like Steam, Epic Games Store or GOG. As such, some gaming giants have decided to build their […]

Continue Reading