Fix Power Query SharePoint Credentials with Read-Only Access in WPS Office
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.

- 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 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.
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.
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.
In WPS Office Spreadsheets, click the Data tab, select Get Data, and choose From Web from the available connectors.
Paste the copied SharePoint file URL into the From Web dialog and continue to the authentication screen.
Select the organizational account option, sign in with the read-only account, and set the credential level for the SharePoint location.
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.

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. Copy the direct workbook path: Open the SharePoint workbook in a browser, click File > Copy Path, and remove ?web=1 from the URL.
- 2. Open From Web in WPS Spreadsheets: Go to the Data tab, click Get Data, and choose From Web.
- 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. 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.

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.




