Reporting - Add 'database last refresh date and time' to a report

*** Please note, this article refers to the All-new Reporting and Analytics. View the FAQ for more details. ***

In this article, we'll show how to add a Card visualisation to a custom report showing the date and time the database was last refreshed. This makes clear to any report viewer, exactly how current the data is.

How often does the reports database refresh?

• The report database refresh twice a day
• A time stamp showing the most recent database refresh is shown in every fixed report
• The 'database refresh' timestamp can also be added to a user-created report
• Each Dataset is refreshed individually, so the time stamp may differ between reports using different Datasets
• Where a fixed report and a user-created report are built using the same dataset, the time stamp will be the same

Steps to add 'database last refresh date and time' to a report

1. Start a new User-created report or open an existing report
2. From the Visualisations panel, select 'Card visualisation'. An empty Card will be added to the report:
3. Check that the Card visualisation is still the selected item on the page. Add the data 'Last refresh date & time with text':
4. Select 'Format visual':
5. Select 'Callout value'. Use the formatting options to amend the text as required:
6. Toggle the 'Category label' to 'Off':

Find out more about reporting and analytics with Microsoft Power BI

Join us live for Key techniques for using Power BI fixed reports in The Academy. We'll start with a tour of the Power BI reporting area, then, we’ll open up the Learning Progress report and using real-life examples, we’ll dive into the detail.

If you're using Reporting and Analytics already and have a question, come along to our 'Ask me Anything' events in the Academy to ask questions and share feedback directly with the team.

Join us for our update and roadmap live event to see the latest feature releases and roadmap for the next quarter and share feedback directly with the team. 

Don't have your Academy account yet? Contact your Customer Experience Manager or the Support Team to sign up today.