Last Refresh of Data

[irnm8dn]

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!

[Greg_Deckler · Accepted solution]

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 · Accepted solution]

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)

[irnm8dn]

Thanks for the clarification.

Below is a representation of the output.  I was expectiing 7/13/2017 3:52:50 PM

Thoughts?

[v-ljerr-msft · Accepted solution]

Hi @irnm8dn,

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). 

= DateTime.Time(DateTimeZone.SwitchZone( DateTimeZone.FixedLocalNow(), -5 )) & DateTime.Date(DateTimeZone.SwitchZone( DateTimeZone.FixedLocalNow(), -5 ))

Regards

[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?