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

Anonymous's avatar
Anonymous
Not applicable
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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you for the solution.

     

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