Forum Discussion
SSRS Local Time in Power BI Service?
Hi All, I am having issue getting local time (With daylight savings etc) in a SSRS report on the Power BI Service. Currently I tried: System.TimeZone.CurrentTimeZone.ToLocalTime(Fields!DateT...
The Solution I found was the following:
Source: https://www.c-sharpcorner.com/UploadFile/ff2f08/dealing-with-time-zones-in-ssrs-reports/
I used the first version, with the function. However I needed to change the format of the start date.
format(Code.FromUTC(format(Globals!ExecutionTime,"yyyy-MM-dd HH:mm:ss"), "New Zealand Standard Time")
The Solution I found was the following:
Source: https://www.c-sharpcorner.com/UploadFile/ff2f08/dealing-with-time-zones-in-ssrs-reports/
I used the first version, with the function. However I needed to change the format of the start date.
format(Code.FromUTC(format(Globals!ExecutionTime,"yyyy-MM-dd HH:mm:ss"), "New Zealand Standard Time")