DateTimeZone.SwitchZone is what I use in my Date dimension to correct dates to local timezone from UTC in the PBI service. The following example was taken from Radacad’s series in creating a date dimension table.
/ configurations start
StartofFiscalYear=7, // set the month number that is start of the financial year. example; if fiscal year start is July, value is 7
DayTime = DateTimeZone.SwitchZone(DateTimeZone.FixedUtcNow(),10,0),
Today=Date.From(DayTime), // today’s date
firstDayofWeek=Day.Monday, // set the week’s start day, values: Day.Monday, Day, Sunday…
FromDate=#date(StartYear,1,1),
ToDate=#date(EndYear,12,31),
Source=List.Dates(
FromDate,
Duration.Days(ToDate-FromDate)+1,
#duration(1,0,0,0)
),