Forum Discussion
Import dates using Locale in Excel
I'm hoping this is a quick fix. On my excel file, the region is set to Australia. When I import this file in Power Query, there are dates in american mm/dd/yy format (unless they cannot be converted). Is there any way to get the data show up the same way in power query, as I cannot use change type with locale if half of my dates are dd/mm/yy. The regional settings for "This File" are also set to English (Australia).
What I ended up doing was manually going to the source excel, changing the locale of that file and fixing the dates. Then I went and refreshed the data, which seemed to work.
3 Replies
NewStep=Table.TransformColumns(PreviousStepName,{"your date column name",each Date.From(_,"en-Au")})
Hey, thanks for the reply.
Unfortunately, I can't use Transform as the dates are showing in mixed dd/mm/yy and mm/dd/yy, due to a locale difference.
What I ended up doing was manually going to the source excel, changing the locale of that file and fixing the dates. Then I went and refreshed the data, which seemed to work.
