Power Query Problems

Fix Excel Power Query Authentication Errors for NSE India Data

Huda QurayshiHuda Qurayshi Nov 14, 2026 869 views

Question details

The user needs to retrieve NSE India JSON data in Excel Power Query without authentication errors.

Product
Microsoft Excel Power Query
Device & OS
not provided
Scenario
Connecting Power Query to NSE India API endpoints, including the allindices endpoint.
Observed behavior
Power Query requests anonymous authentication, and the issue may affect every query using the source.
Before you start

Identify the exact NSE India endpoint used by each query and check NSE India's current terms and documentation for automated access. Confirm whether the endpoint requires an approved API, credentials, or a browser session before changing Power Query permissions.

Solution 1Recommended

Verify NSE India access requirements and reset Power Query permissions

Use this approach to check whether the endpoint permits Power Query access and remove conflicting saved credentials before retrying.

An anonymous authentication prompt does not guarantee that the endpoint accepts automated anonymous requests. NSE India may require an approved access method or browser-like session headers and cookies that the standard Power Query Web connector does not provide.

1
Check the query URL

In Excel, open Data > Queries & Connections, then right-click an affected query and select Edit. Inspect the Source step and note the exact NSE India endpoint.

2
Review permitted access

Check NSE India's official API documentation and terms for that endpoint. Confirm whether automated requests are allowed and which authentication method is required.

3
Clear saved permissions

In Excel, select Data > Get Data > Data Source Settings. Select the relevant NSE India source and choose Clear Permissions, then confirm.

4
Reconnect with the permitted method

Refresh the query from Data > Queries & Connections. When Excel prompts for credentials, select the authentication method specified by NSE India; choose Anonymous only if the endpoint permits anonymous access.

If the error continues: Clearing permissions cannot grant access to a restricted endpoint. Use an authorized NSE India API or connector if one is available, and follow its access requirements.
Free Microsoft Office alternative

Review imported NSE India data in WPS Spreadsheet

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Office format compatibility for an easy transition. Open and analyze data you have obtained through an authorized source; WPS does not resolve Excel Power Query authentication errors.

Review and analyze authorized NSE India data in a spreadsheetOpen and edit Microsoft Excel XLSX and XLS filesWork in a familiar, easy-to-use spreadsheet interfaceUse a free, lightweight Office alternative
microsoft office alternative - wps office

Frequently Asked Questions

Why does Power Query ask for anonymous authentication for an NSE India URL?

Excel may prompt you to choose credentials for a web source, but that prompt does not mean the endpoint permits anonymous automated access. Check NSE India's current documentation for the endpoint's access requirements.

How do I remove saved NSE India credentials in Excel?

Go to Data > Get Data > Data Source Settings, select the relevant NSE India source, and choose Clear Permissions. Refresh the query and provide the authentication method permitted by the service.

Will clearing permissions fix every NSE India query?

Not necessarily. It can remove conflicting stored credentials, but it cannot provide a required browser session or authorization. Check each endpoint's requirements and use an approved API or connector when needed.

Can WPS Spreadsheet fix Excel Power Query authentication?

No. WPS Spreadsheet is an alternative for opening and analyzing spreadsheet data, but it does not fix authentication errors in Microsoft Excel Power Query.