Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Last Refresh date time

Hi

 

I want to show the last refresh date and time from Power BI service on my Power BI report. Is it possible to do.

 

Untitled.png

 

I am scheduling auto refresh of report at 9 am and 1 pm, this field "Refreshed" is changing after refresh. I want to pick this value and show on report. I am planning to use CARD visual in Power bi desktop and want to show "REFRESHED" value from Power bi service so after Publishing report, Power BI service can show refreshed value.

3 REPLIES 3
gpiero
Skilled Sharer
Skilled Sharer

@Anonymous 

Hi,

tiles pinned in your dashboard could display the last refresh.

You will find the option selecting the three dots menu, at right top (if I remember well... at the moment I do not have access on Pro version)

 

Regards

If I can...
Anonymous
Not applicable

I want to set up on report not on dashboard.

@Anonymous 

Hi

In a desktop version the following solution works.

Please check how it works in PBI Pro

 

let
    Source =  #table(type table[LastRefresh=datetime], {{DateTime.LocalNow()}})
 in
 Source

img.PNG

 

Sorry but I am not able to check since I haven't any Pro licence available.

 

Regards

 

 

 

 

 

If I can...

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.