Forum Discussion
Kudo CommanderPower BI Service Automatically Converts PST Date to UTC – How to Keep DB Date as PST?
Hi manoj_0911 ,
Thanks for reaching out to the Microsoft fabric community forum.
Try these Steps to resolve your issue -Load into Power BI Desktop
Create a new table in Power BI or connect to your SQL data source.
Open the Transform Data option to access Power Query Editor.
Apply UTC ConversionIn Power Query, go to Add Column > Custom Column:
DateTimeZone.SwitchZone(DateTimeZone.From([TXN_DATE]), -8)
Rename this new column to TXN_DATE_UTC. This approach applies the PST offset. For daylight saving time (March–November), use -7 or -8.
Before publishing it double-check if the column is correctly typed in Power Query > Data Type for datetimezone.Test in Power BI Service
Publish your report to Power BI Service.
The TXN_DATE_UTC field will display the same as in Desktop, with no additional UTC adjustment.Since you’ve already adjusted to UTC, Power BI Service will keep the date consistent across environments.
Please find the attached .pbix file for your reference.If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it
Best Regards,
Sreeteja.
Community Support Team
Super UserHi manoj_0911 Power BI assumes datetime values are in UTC, leading to auto-conversion. To retain PST, transform the datetime in Power Query using DateTime.AddZone([TXN_DATE], -8) for standard time or adjust dynamically for DST. Use the DateTimeZone type to prevent further adjustments. Ensure visuals explicitly use the transformed column to retain consistency between Desktop and Service.