Power BI: Show Last Data Refresh on Dashboard

 To show last data refresh on Power BI report follow the below steps.

1. Open Report Query Editor Mode.

2. Clink on Get Data -> Blank Query

3. Once you have Blank Query table “Query1” in place under the Queries section, right click on it and rename it to “Last Refreshed Date”

4. Now, open the Advance Editor from the Home ribbon and paste the below M code.

let
Source = #table(type table[Date Last Refreshed=datetime], {{DateTime.LocalNow()}})
in
Source

5. Click on Close & Apply

6. Next step is to add a calculated measure field to use with the Date Last Refreshed column

          Date Last Refreshed = VALUES (‘Date Last Refreshed'[Date Last Refreshed])

 

 

Happy Learning !!