Forum Discussion
Auto refresh indicator
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
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.
10 Replies
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.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 🙂