Fix Excel Power Query Authentication Errors for NSE India Data
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.
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.
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.
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.
Check NSE India's official API documentation and terms for that endpoint. Confirm whether automated requests are allowed and which authentication method is required.
In Excel, select Data > Get Data > Data Source Settings. Select the relevant NSE India source and choose Clear Permissions, then confirm.
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.
Import data from an authorized NSE India source
Use an approved API, connector, or downloadable data source when the standard Web connector cannot meet the endpoint's requirements.
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.

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.




