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

lkshck's avatar
lkshck
Helper III
3 years ago

Hey,

I used the following solution as a little hack as it was way more easier than the Dax solutions from my point of you.

I added a new Web data source to my file with the following URL:

http://worldtimeapi.org/api/timezone/Europe/Berlin

This will give you a new table with date information like utc-time and the time of Europe/Berlin like you can see here:

I added the datetime value to a visual and that's it. Everytime the Report will be refreshed, this value will be also refreshed to the current time.

Maybe this will help you as well 🙂

 

Best regards,

Lukas