Blog Post

Excel Blog
1 MIN READ

Re: New in Excel for the web: Power Query Refresh is now generally available for selected data sources

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jul 10, 2025

MattRoor​

I have adjusted my last step of the query to Change Type Using Locale and set to English(US)

You shall select here not English (US) but the source region. If dates (more exactly texts which represent dates) are in French default format select French (France). If in UK format, select English (UK), etc. With that they will be correctly converted to dates and such dates will be shown in default client regional format, i.e. English (US) on Web, French on desktop with French regional settings, Chinees on desktop in China, etc.

Published Jul 10, 2025
Version 1.0
No CommentsBe the first to comment