Answers for "Power BI add last refreshed time to report"

1

Power BI add last refreshed time to report

1. On the Query Editor window, from the Home ribbon, click on the New Source option. 
2. Next, select Blank Query.
3. Under the Queries section, right-click on the newly created Query1 (1) and select Rename (2).
   (In this example, I renamed the query to Date Last Refreshed.)
4. Now click on the Advanced Editor option, from the Home ribbon, and paste the M code (see below):

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

4. The M code creates a column with the name Date Last Refreshed and it gathers the current date
   and time.
5. Add the column to a card visual and ensure that it uses the "Latest" value
Posted by: Guest on February-10-2021

Browse Popular Code Answers by Language