Auto refresh indicator

[Anonymous]

HI,

Request your valuable guidance to solve this issue of mine 

I have created a dashboard which will automatically refresh data from our server in every 20 minutes. My boss now wants to show an indicator on the dashboard which will display the last refresh date and time.  Kindly advice how i can make this happen

regards,

dsmitha

[SpartaBI · Accepted solution]

@Anonymous you can create a now() measure. It will update when the dataset is refreshed and then you can present it on a card.
You can also do the now() in Power Query as a stand alone query and bring it to the model. Both will work. the dax approach will be simpler.

      

Showcase Report – Contoso By SpartaBI

[Anonymous]

Hi SpartaBI,

Thank you very much for your help, it worked

thanks again

regards

dsmitha

[SpartaBI]

@Anonymous my pleasure 🙂

Check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas. 
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up over there if you liked it 🙂

[Anonymous]

Hi SpartaBI,

I was one of the early birds to thumbs up that masterpiece, really wonderful one

regards,

dsmitha

[SpartaBI]

@Anonymous haha thank you so much my friend! 
Come follow us 🙂
https://www.linkedin.com/company/spartabi

[Anonymous]

thank you and following

regards,

dsmitha

[SpartaBI]

Thank you and really love your microsoft avatar 🙂

[Anonymous]

we both follow Satya Nadella 🙂 

[SpartaBI]

haha the one and only! The king!

[Anonymous]

of course, without doubt