Forum Discussion
Facing Issue in Refresh time
Hai All,
I Am Facing An issue with the last refresh time.
I had used Datetime. local now(), Now() these m queries and Dax
After publishing the report into power bi service whenever the refresh is complete the times are showing differently for example
The last refreshed time is 5/13/2022 11:35 am but after refreshing and if open my report shows the time is 5/13/2022 at 5.45 am
Why this is happening this is only happening on power bi service
And I want to show it on CET Time
Thanks
Alan P James
Hi Anonymous ,
On Power BI Service, the now() function will return the UTC time. We can't set the time zone on Power BI Service. To get the correct local time, we can add time different in your DAX formula, or use Power Query to get the local time zone datetime, for example:
And you can query the Timezonedb.com website that has an api to return timezone information. For more details, please see: Solving DAX Time Zone Issue in Power BI
This video also calls the API to return the time in the corresponding time zone.
https://www.youtube.com/watch?v=2kmFfbOeFJg
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Anonymous ,
On Power BI Service, the now() function will return the UTC time. We can't set the time zone on Power BI Service. To get the correct local time, we can add time different in your DAX formula, or use Power Query to get the local time zone datetime, for example:
And you can query the Timezonedb.com website that has an api to return timezone information. For more details, please see: Solving DAX Time Zone Issue in Power BI
This video also calls the API to return the time in the corresponding time zone.
https://www.youtube.com/watch?v=2kmFfbOeFJg
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.