Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
How would I include a time stamp visual that originates from a dataset that is on an autorefresh schedule q2 hours? The goal is to display the time the data set was last refreshed. Thank you
Solved! Go to Solution.
Yeah, that's because of the time zone offset. Apparently the time zone of the service is +5 hours ahead or -7 hours from your time zone. You can fix that by adding or subtracting hours.
Measure 27 = NOW() + .0416666666667 * (1)
Just adjust the + sign and the 1 as needed.
Include a column in one of your tables that refreshes of TODAY() or NOW(). This will be updated upon refresh.
Thanks. Did that and used NOW(). Looks as expected in desk top, example 12:25 local time which matched, but service is displaying time as 5:18
Yeah, that's because of the time zone offset. Apparently the time zone of the service is +5 hours ahead or -7 hours from your time zone. You can fix that by adding or subtracting hours.
Measure 27 = NOW() + .0416666666667 * (1)
Just adjust the + sign and the 1 as needed.
Created a Quick Measure for this:
https://community.powerbi.com/t5/Quick-Measures-Gallery/TIMEADD/m-p/585280#M278
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.