Forum Discussion
Display report runtime in report
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.
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.