Unable to connect to sharepoint data

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.

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

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.