How to Connect Excel Power Query to an Internal SharePoint Site

To connect Excel power query to an internal SharePoint site, use the correct account, product, permissions, and destination. This guide explains the supported workflow and the checks that confirm the result.

Identify the Exact SharePoint Item, Permission, or Flow

Confirm the owning account, required permissions, affected files or services, and the exact outcome you need. Keep a backup when the task changes local content or removes access.

Quick SharePoint or Flow Check

First, in Excel, select Data > Get Data > From Online Services > From SharePoint Online List or From SharePoint Folder. Next, enter only the SharePoint site URL, not a view or individual-file URL, and select the Organizational account credential type, and verify the final state before changing any backup or secondary account.

How to Connect Excel Power Query to an Internal SharePoint Site

1. In Excel, select Data > Get Data > From Online Services > From SharePoint Online List or From SharePoint Folder
2. Enter only the SharePoint site URL, not a view or individual-file URL, and select the Organizational account credential type
3. Sign in with an account that can open the site in a browser, then choose the required list, library, or folder in Navigator
4. Select Transform Data to filter the source before loading, then choose Close & Load
5. Open Data > Queries & Connections, refresh the query, and confirm that the expected rows and columns load

After the final step, reopen the affected app, portal, file, or account page and confirm the exact status or behavior described in the title.

WPS Office: A Leading Free Alternative to Microsoft Office

WPS Office cannot change the SharePoint tenant, permission, list, or automation state involved in connecting Excel power query to an internal SharePoint site. Use SharePoint, Power Automate, or the Microsoft 365 admin center for that service-side control.

While you work on connecting Excel power query to an internal SharePoint site, WPS Office provides a free Microsoft Office-compatible workspace through WPS Spreadsheets. It opens and saves common DOCX, XLSX, PPTX, and PDF files in a familiar interface, so related local work can continue without waiting for the Microsoft-side issue to be fixed.

For work related to connecting Excel power query to an internal SharePoint site, WPS AI in Spreadsheets can help explain or generate formulas, clean and summarize data, and turn relevant ranges into chart-ready insights without leaving the workbook.

Test advanced macros, add-ins, external connections, sensitivity controls, and Microsoft-only cloud integrations on a copy before moving a critical workflow. WPS AI availability and usage limits can vary by plan, platform, region, and app version.

Practical Checks That Prevent a Repeat

• Record which account, app, and file owns the workflow
• Keep a verified backup before removing access, changing ownership, or replacing a local file
• Apply high-impact changes to one test item or user before expanding the scope
• Save confirmation numbers, dates, and screenshots of the final settings when they affect billing, security, or permissions

Frequently Asked Questions

Which SharePoint address should Power Query use?

Enter the site URL rather than a view, folder, or individual-file URL, then choose the connector that matches a list or document library.

Why does Power Query ask for credentials again?

A saved credential may use the wrong account type or privacy level. Review Data source settings and sign in with the organizational account that can open the site.

Should I load the data before checking column types?

Use Transform Data first. Confirm headers, locale, data types, filters, and row counts before Close & Load.

How can I confirm that connecting Excel power query to an internal SharePoint site was successful?

Open Data > Queries & Connections, refresh the query, and confirm that the expected rows and columns load. Repeat the original action and confirm that the result remains after reopening the app, file, or portal.