Forum Discussion
Last Refresh Date change Timezone
lkshck , I think you should use
Date.From(DateTime.FixedLocalNow())
for timezone refer if this can help
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
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.
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
Of all the options the easiest and most effective is this, spend hours looking for a solution and here simply with new data source the updated time is shown in web version and desktop version in my case I needed to update it at the time of chile and modify the link http://worldtimeapi.org/api/timezone/america/santiago
Of all the fields that come out, which one you take for the board?
