How To Add Last Refreshed Date In Power Bi

by

How to Add Last Refreshed Date in Power BI

Adding the last refreshed date to your Power BI report is useful for providing context to the data and allowing users to know when the data was last updated.

To add the last refreshed date in Power BI, you can follow these steps:

  1. Open your Power BI report in Power BI Desktop.
  2. In the “Fields” pane on the right, locate the table or visualization that you want to add the last refreshed date to.
  3. Right-click on the table or visualization and select “Format” from the context menu.
  4. In the “Format” pane on the right, click on the “Title” section.
  5. Toggle the “Title” switch to “On” if it’s not already enabled.
  6. In the “Title text” field, enter a suitable title for the last refreshed date, such as “Last Refreshed”.
  7. Below the “Title text” field, click on the “Add dynamic title” button.
  8. In the dropdown menu that appears, select “Data source last refresh” option.
  9. Customize the format of the last refreshed date by selecting the “Format” option and choosing the desired date format.
  10. Click outside the “Format” pane to apply the changes.

By following these steps, the last refreshed date will be added to the title of the selected table or visualization, displaying the date and time when the data source was last refreshed.

Example:

Let’s say you have a table named “Sales” in your Power BI report, and you want to add the last refreshed date to it:

  1. Open the Power BI report in Power BI Desktop.
  2. Locate the “Sales” table in the “Fields” pane.
  3. Right-click on the “Sales” table and select “Format” from the context menu.
  4. In the “Format” pane, enable the “Title” switch.
  5. Enter “Last Refreshed” in the “Title text” field.
  6. Click on the “Add dynamic title” button below the “Title text” field.
  7. Select the “Data source last refresh” option from the dropdown menu.
  8. Customize the date format if desired.
  9. Click outside the “Format” pane to save the changes.

Now, the “Sales” table in your Power BI report will display the title “Last Refreshed” followed by the actual date and time of the last data source refresh.

Leave a comment