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