A business user asked me how to show the data refresh time on the Power BI report he build. This is another typical requirement in reporting.
We know that Power BI service provides that feature for scheduled refresh in Pro license. But it's not in Power BI desktop.
I used the Power Query M language to implement it.
First step is creating a table through "enter data":
Then Add a "custom column" call "Refresh Time" with formula:
Apply the changes, now you get a table and a column call "Refresh Time" in it.
Simply drag and drop "refresh Time" in "Card" visual. And it always shows the latest data refresh time.
Comments
Post a Comment