Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Powerbi Last refresh date and time

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 th...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

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.