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!DateTime.Value)
Any thoughts would be great!
Cheers
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")
1 Reply
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")