Forum Discussion
Facing Issue in Refresh time
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.
And My data source is Sharepoint
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.