Power Query Problems

Fix Power Query SharePoint Credentials with Read-Only Access in WPS Office

Bushra ParveenBushra Parveen Nov 13, 2026 868 views

Question details

The user needs to resolve Power Query credential and permission failures when connecting to a SharePoint workbook that only requires read-only access, by using a direct file URL instead of SharePoint.Contents navigation.

Fix Power Query SharePoint Credentials with Read-Only Access in WPS Office
Product
WPS Office Spreadsheets
Device & OS
not provided
Scenario
Users need to refresh or build a Power Query connection to a specific SharePoint workbook but only have read-only permission to the source file or folder rather than Edit permission for the entire SharePoint site.
Observed behavior
Power Query fails with permission or credential errors when navigating the whole SharePoint site through SharePoint.Contents, even though the user can open the workbook directly.
Before you start

Before changing the connection, open the SharePoint workbook in a browser with the read-only account and confirm you can access the file. Copy the workbook path from SharePoint so you can paste it directly into the Power Query From Web dialog.

Solution 1Recommended

Connect directly to the SharePoint workbook using the From Web connector

Use this method when users only need to read a specific workbook and do not have Edit permission for the whole SharePoint site.

Power Query does not need Edit permission for an entire SharePoint site when only a specific workbook must be read. Connecting directly to the file URL with From Web avoids the broader permission checks triggered by SharePoint.Contents navigation.

1
Open the workbook in SharePoint and copy the file path

In your browser, open the source workbook in SharePoint. Click File > Copy Path, then remove ?web=1 from the copied URL so you are left with the direct file URL.

2
Open the Power Query From Web connector

In WPS Office Spreadsheets, click the Data tab, select Get Data, and choose From Web from the available connectors.

3
Enter the direct workbook URL

Paste the copied SharePoint file URL into the From Web dialog and continue to the authentication screen.

4
Configure organizational authentication

Select the organizational account option, sign in with the read-only account, and set the credential level for the SharePoint location.

5
Grant read-only access to the required folder or file

In SharePoint, confirm that the account has read-only access to the source workbook or the Template folder that contains it, and then load the query.

Connect directly to the SharePoint workbook using the From Web connector
Read-only access is sufficient: Connecting to the file URL directly allows Power Query to retrieve the workbook without requiring Edit permission on the entire SharePoint site.

Use Read-Only SharePoint Workbooks in WPS Office Power Query

In WPS Office, connect Power Query to the direct SharePoint workbook URL with organizational authentication so users can refresh data with read-only access instead of granting full-site Edit permissions.

  1. 1. Copy the direct workbook path: Open the SharePoint workbook in a browser, click File > Copy Path, and remove ?web=1 from the URL.
  2. 2. Open From Web in WPS Spreadsheets: Go to the Data tab, click Get Data, and choose From Web.
  3. 3. Authenticate with the read-only account: Paste the direct file URL, select organizational authentication, and sign in with the account that has read-only access to the file.
  4. 4. Load the workbook into Power Query: Confirm the connection settings and load the workbook into WPS Office to refresh it without needing full-site Edit permissions.
Uses a direct file URL to avoid SharePoint.Contents permission failuresLets team members refresh Power Query data with read-only SharePoint accessMaintains Microsoft Excel workbook and Power Query connection compatibilityProvides a free, lightweight Office suite with familiar Data and Get Data ribbon tools
microsoft office alternative - wps office

Frequently Asked Questions

Do I need Edit permission on the entire SharePoint site for Power Query?

No. If users only need to read a specific workbook, grant read-only access to that file or its Template folder and connect directly to the file URL using From Web. SharePoint.Contents navigation is what often requires broader permissions.

Which connector should I use instead of SharePoint.Contents?

Use Data > Get Data > From Web in WPS Office Spreadsheets and paste the direct SharePoint workbook URL. This avoids navigating the entire SharePoint site.

How do I remove ?web=1 from a SharePoint file URL?

In SharePoint, open the workbook and choose File > Copy Path. Paste the copied URL and delete ?web=1 from the end before using it in the From Web connector.

Can I use organizational authentication with a read-only SharePoint account?

Yes. In the From Web authentication window, select the organizational account option and sign in with the account that has read-only access to the source file or folder.

Why does SharePoint.Contents show a credentials error when I can open the workbook?

SharePoint.Contents may try to enumerate the whole SharePoint site, which can require broader permissions or a different credential level. Connecting directly to the file URL limits the request to the workbook you can already read.