Forum Discussion
cst vs gmt
Hi all,
My power bi reports are being updated by CST (US) time.
I scheduled auto-refresh to have the CST time on Power BI by using the following calculated column:
Adjusted Time = now()-(6/24)
But after 6 pm (CST) today's transaction starts to show as yesterday's transaction.
If I use Date time instead of Adjusted Time = now()-(6/24), then the Refresh time in Powe BI Service report pages will show the time 6 hours before
Anyone can help me fix this dilemma
Thank you
1 Reply
Hi, YavuzDuran
If a manual refresh is subsequently performed, will the refresh time in the Power BI service report page still show the time 6 hours before?
Maybe you need to do that in Power Query.
https://docs.microsoft.com/en-us/powerquery-m/datetimezone-switchzone
You can also check if the solution in these related threads could help:
https://community.powerbi.com/t5/Desktop/UTC-GMT-Issue-on-Report/m-p/1708645
https://community.powerbi.com/t5/Service/UTC-GMT-Issue-for-Reports-Built-from-D365/m-p/1833139
Best Regards,
Community Support Team _ Eason
