Forum Discussion
Last Refresh of Data
For months I have been successfully using the following DAX statement to ashow a Last Refresh Date/Time on my dashboards. This was working with successfully, however since scheduling refrsesh using a personal gateway it seems to be in a less preferred timezone. (For those of you wondering, I have the refresh set to Eastern which is preferred but seems tro be showing UTC on the dashboard.)
= DateTime.Time(DateTime.LocalNow()) & DateTime.Date(DateTime.LocalNow())
Looking for suggestions that will allow me to show Eastern Standard Date/Time when refreshed.
Thanks for the help!
Not to be picky, but that's Power Query "M" language, not DAX. You should be able to use:
DateTime.Time(DateTime.LocalNow()) + #duration(0, -5, 0, 0)
Hi Anonymous,
There is a known gap for the time zone displayed in Power BI Service. The time zone in the service is effectively always set to UTC.
There is a workaround to display time in your current time zone. You can use following power query in the Query Editor if your time zone is 5 hours behind Coordinated Universal Time (UTC−05:00). :smileyhappy:
= DateTime.Time(DateTimeZone.SwitchZone( DateTimeZone.FixedLocalNow(), -5 )) & DateTime.Date(DateTimeZone.SwitchZone( DateTimeZone.FixedLocalNow(), -5 ))
Regards
4 Replies
- Greg_Deckler
Community Champion
Not to be picky, but that's Power Query "M" language, not DAX. You should be able to use:
DateTime.Time(DateTime.LocalNow()) + #duration(0, -5, 0, 0)
- Greg_Deckler
Yes, see formula above. Essentially, it is adding/subtracting hours from the date/time value returned from LocalNow to account for the time zone shift. In your case it looks like you would want to use +5?