Forum Discussion
Difference between date calculation value in Desktop v Report Service
- 5 years ago
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!
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!