
Enter your credentials and chose which level to apply these settings to. If this is the first time you've visited this site address, select the appropriate authentication method. If the URL address you enter is invalid, a warning icon will appear next to the Site URL textbox. Paste the SharePoint site URL you copied in Determine the site URL to the Site URL field in the open dialog box.

Copy the address from your web browser's address bar and save for later.Ĭonnect to a SharePoint list from Power Query Desktop 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. To find the site URL that contains your SharePoint list, first open a page in SharePoint.


When you're connecting to a SharePoint site, you'll be asked to enter the site URL. AAD/OAuth for SharePoint on-premises isn’t supported using the on-premises data gateway.
