If you are working on Power BI, this is a good to know tip.
In case you were using Import mode which is by default suggested by Microsoft for medium or small-scale datasets as it uses Vertipaq engine for improved performance and compression, this post is definitely for you.
Did your user ever asked why they were not able to see latest data in the report. Possibly you could have said it is because of refresh frequency.
Then you could have thought if there was a nice way to show when the dataset was last refreshed. This definitely help your users to have a clear idea of what’s going on.
FYI, the refresh frequency could be set in Power BI service as below for import mode.
In your Power BI report, click on Transform data.
Click on New Source –> Blank Query as below.
In the Query Fx expression…. enter the below expression to get the last refresh time and click on Tick symbol.
Next, click on To Table to create a table from this data as below.
Rename it to something meaningful like below.
Rename the Query1 variable as below..you should see the applied steps getting added for each operation you performed.
DateTime.LocalNow() gets the last refresh frequency of your dataset in your local time.
Click on Close & Apply…
Now in your report, just add a card visual at the bottom right corner and drag the Last Refreshed On query.
That’s it, next time onwards, you should see the date and time when the refresh had occurred.