Unable to connect to sharepoint data

[MatthewCarter]

I am very new to Power Bi and when i first started i was able to connect to a data set in sharepoint. However i keep getting the error message below, it does however let me connect to data on my own computer:

[lbendlin · Accepted solution]

This usually happens when you attempt to connect to anything other than the site URL.  The Sharepoint Folder connector only accepts site or subsite URLs, and will then offer you the list of all files and folders under that site or subsite.

[christinepayton · Accepted solution]

It'd help if you shared the (somewhat redacted) URL you're trying to use. It wants a very particular URL depending on which connector you're using, usually the site URL, so something like https://something.sharepoint.com/sites/sitename

[Anonymous · Accepted solution]

Hi @MatthewCarter ,

You should paste the SharePoint Online site url.

When you're connecting to a SharePoint site, you'll be asked to enter the site URL. To find the site URL that contains your SharePoint Online list, first open a page in SharePoint. From a page in SharePoint, you can usually get the site address by selecting Home in the navigation pane, or the icon for the site at the top. Copy the address from your web browser's address bar and save for later.

Please check if your url is correct.

Here're the official documents:

Power Query SharePoint Online list connector - Power Query | Microsoft Learn

Power Query SharePoint folder connector - Power Query | Microsoft Learn

Power Query SharePoint list connector - Power Query | Microsoft Learn

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[christinepayton · Accepted solution]

It'd help if you shared the (somewhat redacted) URL you're trying to use. It wants a very particular URL depending on which connector you're using, usually the site URL, so something like https://something.sharepoint.com/sites/sitename

[MatthewCarter]

https://albionwater.sharepoint.com/sites/Albion-Intranet/Core%20Business/Data%20Warehouse.xlsx

[lbendlin]

The site URL would be https://albionwater.sharepoint.com/sites/Albion-Intranet

Unless your sharepoint has subsites.  Do you know if that is the case?

[MatthewCarter]

I dont think so, the sharepoint is new and the file is saved as below:

[lbendlin · Accepted solution]

This usually happens when you attempt to connect to anything other than the site URL.  The Sharepoint Folder connector only accepts site or subsite URLs, and will then offer you the list of all files and folders under that site or subsite.