Forum Discussion

Arranafc19's avatar
Arranafc19
Helper IV
5 years ago
Solved

Difference between date calculation value in Desktop v Report Service

Hi   Has anybody been having any issues lately relating to a difference in time between the Power Bi Service and the desktop ?   I have a dax measure which is  Date of Last Refresh = NOW()  whi...
  • _sfrost's avatar
    5 years ago

    Arranafc19 

    Power BI Service generally uses UTC time. Since you are using NOW() in your calculation, when the dataset is refreshed in service, it will take the UTC time, which could be different from the datetime you see in desktop which depends on the local system datetime.

    If you want to see the same datetime as Power BI service, you can play with UTCNOW() function in your calculations.

     

    Did I answer your questions? Give a thumbs up and accept this post as solution!