Forum Discussion
Use API to build calendar based on your timezone
Hello,
I built a Log Management System that tracks the status's of various logs and triggers alerts dependent on the values of their status's. After publishing my report to Service I have stumbled into the UTC time clock sync problem. All of my relative date filters are reporting UTC time and causing reporting/alerting innaccuarcies when the report refreshes and the filters are reading today's date as the next day per UTC time.
I got around displaying current refresh time by using an API to display EST timezone for data refreshes. Now I am curious if anyone has solved this general issue by building a calendar using an API to display all dates/times accoding the API generated calendar?
If anyone has successfully done this please let me know your solution to work through my current issue. It would be much appreciated. I am open to other methods as well.
2 Replies
ksicard2430 , there are few solutions around timezone. But not using API.
See if they can help
https://www.poweredsolutions.co/2019/10/21/handling-different-time-zones-in-power-bi-power-query/
https://support.helpshift.com/kb/article/how-do-i-set-my-timezone-in-power-bi/
amitchandak Is the helpshift article up to date? From everything I have found it is not possible to change timezones within Power BI Service.
The other link you provided will change the timezones in Power BI Desktop but once posted to service it reports UTC time.
Do you have any suggestions for after the report is posted to Power BI Service? I may be missing something here so please let me know if I did.
