Forum Discussion

Ayushi_10's avatar
Ayushi_10
Regular Visitor
2 years ago

Power Bi service

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.

Need Help

2 Replies

  • ibarrau's avatar
    ibarrau
    Super User
    2 years ago

    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.