Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Good day,
I am having an issue where the dates from a raw data file are showing correctly as MM/DD/YYYY HH:MM (military time). When I add the data file into PowerQuery, it changes it automatically to DD/MM/YYYY HH:MM. Is there a way to default the data input to a specific format?
Solved! Go to Solution.
Hi @Ed1100
Did you set it as the steps i followed before, the locale shoud be set as US. Can you provide the steps you operated?
Best Regards!
Yolo Zhu
When I bring the data in, it comes in as a Text.
After I Promoted Headers, I try to Changed Type to Date/Time, it errors out and I cannot figure out why (see error on bottom).
Hi @Ed1100
Did you set it as the steps i followed before, the locale shoud be set as US. Can you provide the steps you operated?
Best Regards!
Yolo Zhu
Hi Yolo Zhu, I was able to correct it by completed the steps with the Change Type with Locale. Not sure why it defaulted back. Thanks for your support!
Hi @Ed1100
If your data format is "MM/DD/YYYY HH:MM", You can select the date column, then select change type->use locale.
Then select the data type to 'Date/Time', and select the locale to "US".
Output
And you can refer to the following link.
Change Type Using Locale with Power Query • My Online Training Hub
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.