SSRS Local Time in Power BI Service?

[Anonymous]

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

[Anonymous · Accepted solution]

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")