Forum Discussion
Helper VLast 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.
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/
Helper VThis 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?
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
Thanks. Yes, i thikn this is the only real way to do this. Bit of an overkill, but thank you very much. can see why Dataflows work this way... Thanks for your time and help on this.
You're welcome and I agree. I've seen how using date/time M functions can make it work, theoretically, but haven't been able to get it to work in practice.