Forum Discussion
andyor
Resolver I
Resolver Idates all converting to American format - urgent help please
All of my dates for every report in my companys workspaces have converted to american date format all of a sudden, meaning all data is showing incorrect. Power BI desktop and service now both think 8...
FreemanZ
Super User
Super Userhi andyor
it seems the locale setting is improper. Try:
1) In PQ, right click the date column header, and then select Change Type > Using Locale.
2) In the Change Type with Locale dialog box, select a data type and locale.
3) Select OK.
https://learn.microsoft.com/en-us/power-query/data-types
This worked perfectly thank you!