How do you get a latest Refresh Date in Microsoft Power BI report

Posted On June 24, 2020 by Sandip Patel Posted in 

In this blog we will learn how to get a last refresh date in Microsoft Power BI report. So, using this practice, we will know last data refresh and also knows the problem with dataset refresh. In order to get latest refresh dates, you have to follow the below steps.

Step 1: Open your report in “Power BI Desktop”.

A screenshot of a social media post

Description automatically generated

Step 2: Click on Transform data, it will open Power query

A screenshot of a social media post

Description automatically generated

Step 3: Click on New Source, select Blank query.

A screenshot of a video game

Description automatically generated

Step 4: Enter DAX expression: = DateTime.LocalNow() and also change the name

A screenshot of a social media post

Description automatically generated

Step 5: Before use its need to convert into To Table.

A screenshot of a social media post

Description automatically generated

Step 6: Rename the column name like DateTime

A screenshot of a social media post

Description automatically generated

Step 7: Click on Close & Apply

A screenshot of a social media post

Description automatically generated

Step 8: Drag the Datetime field in report and apply card level visualization.

A screenshot of a social media post

Description automatically generated

It will work when you refresh the whole model, it will not refresh the date when individual table refresh.

Hope this helps!


Share Story :