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.
Hi,
I have cretaed a report which is used by users from different parts of the world and i have put the last refresh date using this:
But when i publish it on the service and refresh the report on service it always shows the UTC time.
I want to display the time according to any of the user's timezone who is using the report.
Note: Users are from all of Asia.
Solved! Go to Solution.
Hi @Anonymous,
AFAIK, power bi service always converts your date fields to UTC formula after you publish it. Currently, it does not support to dynamic change date range based on the user region.
I'd like to suggest you create user table with offset fields based on user regions, then you can add a calculated field to your table to manually calculate out the local time based on related offset field.
Regards,
Xiaoxin Sheng
Hi @Anonymous,
AFAIK, power bi service always converts your date fields to UTC formula after you publish it. Currently, it does not support to dynamic change date range based on the user region.
I'd like to suggest you create user table with offset fields based on user regions, then you can add a calculated field to your table to manually calculate out the local time based on related offset field.
Regards,
Xiaoxin Sheng
Thank you for the solution.
I have created a custom column to offset the time by the required difference according to the country filter.
https://radacad.com/solving-dax-time-zone-issue-in-power-bi
Note that "last refreshed time" has very limited meaning and/or can be misleading. It is much more important to have a "last modified" column in your actual data and you should display that instead.
Refreshes will happily reload data from the data source even if that data has not changed at all.
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.