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
hectorveram's avatar
hectorveram
Frequent Visitor
3 years ago

Hi, good day,

I am an Amateur Bi User 🙂 

 

I have the Same issue, on the Bi App it shows correct date and time, but on Web Report show UTC time (in this case +4) is there any way to fix this?

i have used this Dax to get Dataset Refresh time but still with this issueDax usedDate & time on Bi App with correct timeDate & Time on Bi web

let
Source = #table(type table[Date Last Refreshed=datetime], {{DateTime.LocalNow()}}),
    #"Tipo cambiado" = Table.TransformColumnTypes(Source,{{"Date Last Refreshed", type datetime}})
in
#"Tipo cambiado"

 

Very appreciate the help

 

Thanks

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

In the end I subtract the number of hours of difference from the UTC so that at the end of publishing the report I would keep the correct date and time. This causes that in the desktop report the time is not correct.