Display correct refresh time on report

Anonymous — Tue, 31 Oct 2023 16:50:16 GMT

I have two questions on this topic.

First, does anyone have sample code to use in a Power BI report to enable it to show the refresh time in eastern time (US) rather than UTC time. Also need the time to be correct for daylight savings time and it needs to display correctly when the report is published. I have experimented with some code to do this and it never seems to quite work.

Second, I have inserted code to pull time from a timeserver (worldtimeapi.org) and it works. However, the site mentions that they have frequent downtime and may not be robust enough for business use. Is there a preferred site to pull time into a Power BI report? While this method is working, time really needs to be calculated in the report without external dependencies. Also, is there a US government time server – all I found was NIST and it didn’t appear to be setup to be used in this way.

Re: Display correct refresh time on report

PijushRoy — Thu, 02 Nov 2023 09:13:01 GMT

Hi Anonymous

Please convery the UTC time to EST time
https://intellitect.com/blog/convert-utc-local-time-daylight-savings-support-power-bi/#:~:text=SwitchZone()%20replaces%20ToLocal(),date%2Dtime%20is%20in%20DST.

Appreciate your KUDOS 👍 and if solved, mark as SOLUTION

topic Re: Display correct refresh time on report in Developer

Display correct refresh time on report

Re: Display correct refresh time on report