How to Add Data Refresh Date in Power BI
In Power BI, you can add the data refresh date to your reports or dashboards to provide users with information about the last time the data was updated. This can be helpful in ensuring users have the most up-to-date information and can trust the accuracy of the data being presented.
To add the data refresh date in Power BI, follow these steps:
- Open your Power BI report or dashboard in Power BI Desktop.
- In the toolbar, click on the “Insert” tab.
- Click on the “Text box” button to insert a new text box into your report or dashboard.
- Click on the newly inserted text box to select it.
- In the “Visualizations” pane on the right side of the screen, expand the “Fields” section.
- Drag and drop the desired date field from your dataset into the “Values” section of the text box.
- With the text box still selected, go to the “Format” pane in the right-side pane.
- Under the “General” section, you can customize the appearance of the text box, such as font size, color, and alignment.
- Under the “Data label” section, you can format the date field as desired, such as changing the date format or including the time.
- Optionally, you can add additional text or labels to the text box to provide context or description for the data refresh date.
By following these steps, you will be able to add the data refresh date to your Power BI report or dashboard. This will update automatically whenever the data is refreshed, providing users with the latest information about the data’s freshness.
Here’s an example of how the data refresh date could be displayed in a text box in Power BI:
