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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.