Is it possible to add a card in power BI that shows the last time the underneath dataset has been updated?
Many thanks!
4 Answers
The below code is working for me (for HK). Add a column with the below formula
Last Refresh = FORMAT(UTCNOW()+TIME(8,0,0),"dd MMMM YYYY ttttt")
Depending on the location it's really confusing with all those functions.. Let me suggest you the workable one: Go to the:
Query Editor 1.right click on the Queries body on the left side 2.new queries 3.Blank Queries 4.Paste the following formula by putting the right Server Instances and DB Name, " = Sql.Database("Server\Instance", "Database", [Query="select GETDATE() LastRefreshDate from AnyTableName"])
It'll work out. And since it's pulling directly from the server,, you don't have to worry about choosing the right DateTimeZone functions in PowerBI.
Related