cst vs gmt

[YavuzDuran]

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 

[v-easonf-msft]

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