Forum Discussion

katto16's avatar
katto16
Icon for Helper I rankHelper I
2 years ago

Time zone conversion not working in Power BI service

I've been trying this using a few different formulas and it wasn't working. In Pbi service, when the report was just published, it worked but after a while, it went back to UTC.   DateTimeZone.Swi...
Need Help
arvindsingh802's avatar
arvindsingh802
Icon for Community Champion rankCommunity Champion
2 years ago

Instead of DateTimeZone.LocalNow(), use DateTimeZone.UtcNow()
as LocalNow will give you time of the region in which your power bi tenant/capacity resides.

katto16's avatar
katto16
Icon for Helper I rankHelper I
2 years ago

I tried this and tested it by publishing it inside my own workspace, it worked. But when i published it inside the premium workspace, it didn't work. It was still UTC. Does it have smth to do with the premium workspace settings?