Forum Discussion
Last Refresh Date change Timezone
lkshck , I think you should use
Date.From(DateTime.FixedLocalNow())
for timezone refer if this can help
lkshck , I think you should use
Date.From(DateTime.FixedLocalNow())
for timezone refer if this can help
Will the first solution uses my local time also in PowerBI Service? If yes, this should be fine. I want to avoid adding new data sources if it's not really needed 😄
Date.From(DateTime.FixedLocalNow()) didn't worked. So if there isn't any build-in solution I will go with the external solution.
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 SourceRegards,
Xiaoxin Sheng
Great, it worked excellent!!
