Display report runtime in report

[PLHM]

Good day

I am wanting to show the time a user runs the report in the top of the report. Currently it works 100% in Desktop but once published it then shows the UTC time, how can I show the date and time in local time zone please?

Thank you in advance

[PLHM]

Nothing sadly has given me what I was after nor expecting and while a "sort of solution" obtained through the above none work how expected although do work, so as much as they work they are not the expected and therefore no solution in my mind

[v-lgarikapat]

Hi @PLHM ,

Apologies for the inconvenience.

I recommend submitting this scenario as a feature request on the official Fabric Ideas forum. The Product Team actively reviews submissions there, and suggestions with strong community support are often considered for future enhancements.

https://ideas.fabric.microsoft.com/

We appreciate your engagement and thank you for being an active part of the community.

Best regards,
Lakshmi.

[v-lgarikapat]

Hi @PLHM , 

Thanks for reaching out to the Microsoft fabric community forum.

@Shahid12523 , @MasonMA , @FBergamaschi , 

Thanks for your prompt response

We’d like to confirm whether your issue has been successfully resolved. If you still have any questions or need further assistance, please don’t hesitate to reach out. We’re more than happy to continue supporting you.

We appreciate your engagement and thank you for being an active part of the community.

Best Regards,
Lakshmi.

[PLHM · Accepted solution]

Sadly seems other than API and the likes there is no "automatic" dunamic way for this to be accomplished like almost every other product caters for, very disappointing. I will have to go through the options listed, which while some appear to be able to achieve what I need whether they will actually work the way I hope and with the restrictions palced on users time will only tell.

[Shahid12523]

Here are a few solid workarounds to display local report runtime:

Option 1: Manual Offset in DAX
If your local time zone has a fixed offset (e.g., IST is UTC+5:30), you can adjust it like this:
LocalNow = NOW() + TIME(5,30,0)

- Works well if daylight saving isn’t a concern.
- You can display this in a card visual at the top of your report.

Option 2: Power Query with Offset
In Power Query, use this pattern to convert UTC to local time:
DateTime.AddZone(DateTimeZone.RemoveZone(DateTimeZone.UtcNow()), 5, 30)

- This gives you IST (UTC+5:30).
- You can store this as a parameter or table value and reference it in visuals.

Option 3: Dynamic Time Zone via API (Advanced)
If you need daylight saving or dynamic time zone logic:
- Use a Web API like TimeZoneDB or WorldTimeAPI to fetch current local time.
- Parse the response in Power Query and display it in your report.
- This method works even when DST shifts.

[MasonMA]

Hello @PLHM 

I'd recommend going through this article from Miguel. 

https://www.thepoweruser.com/2019/10/21/handling-different-time-zones-in-power-bi-power-query/

[FBergamaschi]

This should solve

https://radacad.com/showing-current-time-and-latest-refresh-time-at-local-timezones-in-the-power-bi-...

If this helped, please consider giving kudos and mark as a solution

@me in replies or I'll lose your thread

Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page

Consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

[PLHM]

@FBergamaschi 
While yes that could be a solution one then needs to maintain a table of all users and what time zone they are in, in an organization where access to the reports is around 1000 people that is not feasible, as they are all over the world, as well as moving around the world at times, granted not often, but they do move. 

Using TimeZone.Current I can get the name of the TimeZone the reprot is run from, which then means I "just" need to maintain a timezone table based on that, however if I could pull out that X timezone is UTC + or - X that would be far more dynamic