Powerbi Last refresh date and time

[Anonymous]

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.

[v-shex-msft · Accepted 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

[Anonymous]

Thank you for the solution.

I have created a custom column to offset the time by the required difference according  to the country filter.

[lbendlin]

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.