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.
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.
SpartaBI Logo
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
Showcase Report – Contoso By SpartaBI
10 Replies
- SpartaBI
Community Champion
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.
In case it answered your question, please accept the solution to help other members find it. Appreciate Your Kudos.
SpartaBI Logo
Visit SpartaBI website Visit SpartaBI Linkdin Visit SpartaBI Facebook
Showcase Report – Contoso By SpartaBI- 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 🙂