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

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 :

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close