Stop Auto Date Conversion in Power Query

[powerbi_ex]

How to keep a date format as it came in from SQL Server?   Power Query changes the format automatically.  How to stop this change or revert back?

[v-menakakota]

Hi @powerbi_ex ,

Thank you for reaching out to us on the Microsoft Fabric Community Forum.

Thank you @lbendlin  for providing the possible solution. Power Query can handle time zones, but Power BI does not. If dealing with time zone-aware data, manually adjust using Power Query’s DateTimeZone functions.

If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.

[lbendlin · Accepted solution]

For unstructured data: To stop it:

To revert it remove the "Changed Type"  step that was automatically added.

For data coming from SQL you can overrided it by clicking on the type icon, but Power Query is doing exactly what SQL server meta data is telling it to do, so you better leave that alone.

Bonus tidbid:  While Power Query knows how to handle timezones, Power BI has no idea what these are.