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
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 Conversion
In 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
Hi manoj_0911
May I ask if you have resolved this issue? If so, please mark the helpful reply and Accept it as the solution and give a 'Kudos'. This will be helpful for other community members who have similar problems to solve it faster.
Hi manoj_0911 ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you
Hi manoj_0911 ,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.