Forum Discussion

lkshck's avatar
lkshck
Helper III
4 years ago
Solved

Last Refresh Date change Timezone

Hey, I added a new Table with one column to my report which should show the Last Refresh Date. I've created it with the following query: let Source = #table(type table[Date Last Refreshed=datetime...
Need Help
lkshck's avatar
lkshck
Helper III
4 years ago

Date.From(DateTime.FixedLocalNow()) didn't worked. So if there isn't any build-in solution I will go with the external solution.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi lkshck,

AFAIK, the current power bi service does not support DateTime values with the specific time zone. The DateTime with timezone will be force converted to UTC format if you used them on the power bi service side. 

For this scenario, I'd like to suggest you get the 'UTC NOW' on the desktop side and manually calculate it with the timezone offset to keep it shown in the specific timezone.

let
    //#duration(days, hours, minutes, seconds) function and negative/positive number to fix UTC to specific local timezone
    Source = DateTimeZone.UtcNow() + #duration(0,8,0,0)
in
    Source

Regards,

Xiaoxin Sheng

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    2 years ago

    Great, it worked excellent!!