Power Bi service

[Ayushi_10]

I want  the latest updated time of my data in powerbi desktop . To achieve this I have written down "date.localnow()" . when i published my report to power-bi service it is showing different tiings . After research I got to know that power-bi service shows UTC timings But I am unable to find the solution . I have checked that power bi service data is in Ireland timezone .How can I achieve the same Indian  timings in power bi service as it is showing in Power bi desktop.

[aj1973]

Hi @Ayushi_10 

Use DateTime.FixedLocalNow() instead.

[ibarrau]

Hi. If it's just one date, I have learn that is way easier to convert it to a different timezone adding or substracting hours than trying to change the default way of showing hours of power bi. You can easily change the date with a simple measure at the table running "date.localnow()". For example for UTC+1

DateTime Ireland UTC+1 = MAX(TableTypes[DateTime]) + 1/24

You can add or substract days for datetime, but if it's a decimal, then you can play with days. So 1/24 would be one hour.

I hope that helps to keep it simple.