Power Query wrong date format

[MikeWarakom]

Hi,

Today I have started to get some issues with dates:

1. Format is US

2. Setup is for UK

3. The locale option does not change the date format

4. I get errors when I pull data to the model

5. I have been using this table for 2 years, issues started only today

I would be grateful for any solutions, I do not want to remodel again dates table.

[v-yetao1-msft]

Hi @MikeWarakom 

Choose the Date column and change the date format .

Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[MikeWarakom · Accepted solution]

Hi,

I had to delete and rebuild the dates table in the dataflow. That solved the issue. Thanks!