Forum Discussion
Last Refresh Date in PowerBi
PPStar You can use some simple API calls like what I have done in the attached .pbix. Remember though, the visualizations will still need to be refreshed aven after the dataflow and report refreshes.
PPStar So you're bringing in the MIN or MAX date from your dataflow into a card visualization? Are there unique dates in that column? What is your time in UTC? When you note that the column needs to consider time changes, are you referring to DST?
I just want a date that shows the last refresh of the dataflow. The last refresh datetime column is a DateTime format.
It just going to be displayed as a Table in the report.
For me, UTC time is -1.
I am on BST (British summer time), its 13:54 here now, so UTC is 12:54
I thought that might be the case. It sounds like you might be dealing with a disconnect between your local time and the server time and might need to use a different M date function. Check out this blog and see if there's anything helpful to you:
https://blog.crossjoin.co.uk/2017/03/28/daylight-saving-time-and-time-zones-in-m/
This doesnt not work for me..
We have a global user base, i.e. users in US, Australia, UK, Europe etc.
The solution needs to show to their local time. So for e.g. if the dataflow in the service shows UTC, depending on what country the user is in, the time should change to reflect their time zone.
Is this even possible?