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”.
Step 2: Click on Transform data, it will open Power query
Step 3: Click on New Source, select Blank query.
Step 4: Enter DAX expression: = DateTime.LocalNow() and also change the name
Step 5: Before use its need to convert into To Table.
Step 6: Rename the column name like DateTime
Step 7: Click on Close & Apply
Step 8: Drag the Datetime field in report and apply card level visualization.
It will work when you refresh the whole model, it will not refresh the date when individual table refresh.
Hope this helps!