Forum Discussion
Solved
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)...
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.
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.