Fix Excel Power Query Website Login Before Importing Data
Question details
The user needs to authenticate to a website before importing its data into Excel Power Query.

- Product
- Microsoft Excel Power Query
- Device & OS
- not provided
- Scenario
- Connecting Excel to a website that requires a login before its data can be accessed.
- Observed behavior
- Power Query displays a static login page instead of allowing the user to complete the website's interactive sign-in flow.
Confirm the URL of the actual data page or endpoint and check which authentication methods the website supports. In Excel, check File > Account > About Excel for your version; menu names and connector options may vary by build.
Check Power Query Data Source Credentials and Privacy Settings
Use this approach when the website or data endpoint supports an authentication method offered by the Web connector.
Power Query does not support every interactive website login flow. A sign-in form rendered as a static page may require a different data endpoint or export method.
In Excel, go to Data > Get Data > Data Source Settings. Select the website's data source and choose Edit Permissions to review its credentials and privacy level.
Choose Edit under Credentials and select an authentication method supported by both the endpoint and the connector, such as Basic, Windows, Organizational Account, or Web API, if available. Enter the requested credentials and save them.
In Edit Permissions, set the privacy level appropriate for the source and your organization's policies. Do not disable privacy protections just to bypass the login page.
Select Data > Get Data > From Other Sources > From Web, enter the data endpoint URL, and sign in with the supported method when prompted. Select the data to load if the connection succeeds.
Import Data from a Supported API or Website Export
Use an API or exported file when the website's browser-based sign-in cannot be completed in Power Query.
Work with Exported Website Data in WPS Spreadsheet
WPS Office is a free, lightweight Office alternative with a familiar interface for working with downloaded website data. Open compatible files in WPS Spreadsheet for an easy transition, although WPS does not fix Excel Power Query authentication.

Frequently Asked Questions
Why does Power Query show a login page instead of my data?
The website may require an interactive browser login that Power Query cannot complete. Check whether the site offers a data endpoint with supported authentication, an API, or a downloadable export.
Where can I change the credentials Power Query uses for a website?
In Excel, go to Data > Get Data > Data Source Settings, select the source, and choose Edit Permissions. Under Credentials, choose Edit and select a method supported by the endpoint.
Can I use the old New Web Query browser to sign in?
The older browser may not be available in your Excel version. Instead, use a supported Web connector authentication method or ask the website provider for an API or export.
How do I import data if the website only offers a CSV download?
Download the CSV from the website, then choose Data > From Text/CSV in Excel and select the file. You may need to download an updated file before refreshing the import.




