Tokyo Stock Exchange data

Hello OferP2023​,

Thank you for the clarification.

The message “We couldn't authenticate with the credentials provided” commonly occurs when Power Query has stored credentials for the website that are not compatible with the authentication method required by the site.

You can resolve this by clearing the stored permissions and reconnecting.

Open Excel and go to Data > Get Data > Data Source Settings. Locate the website used in the query, select it, and choose Clear Permissions. After that, run the query again. When Excel prompts for authentication, select Anonymous. Public financial data pages typically require Anonymous access.

Power Query stores credentials at the domain level. If an incorrect authentication method was selected earlier, the query may continue to fail until the stored permissions are cleared.

For Tokyo Stock Exchange data, you can maintain a list of tickers in Excel such as 7203.T for Toyota and then use Data > Get Data > From Web to retrieve the information. Once configured, the query can be refreshed to update multiple stocks automatically.

Microsoft documentation about connecting to web data with Power Query is available here:
learn.microsoft.com/en-us/power-query/connectors/web/web

Please also note that some financial websites restrict automated queries. In those cases Power Query may not be able to retrieve the data even though the page opens normally in a browser.

If this information helps resolve the issue, please consider marking the reply as the answer so it may assist others in the community.