Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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 ...
Need Help
Show and Tell
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    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)
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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