cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

How to add Dataset's Last Refresh Date on your Power BI report.

Hi,

 

Can anyone please let me know how can I display dataset's last refresh date of my power bi report? I want to display below date. I want this option on report, not on dashboard.

I  Capture.JPG

 

Shikha

7 REPLIES 7
ssugar Member
Member

Re: How to add Dataset's Last Refresh Date on your Power BI report.

Create a new Blank Query, and then add this into the Advanced Editor:

 

let
    Source = DateTimeZone.FixedUtcNow()
in
    Source

 

Then any time your report is refreshed, you'll be able to use this to show the date/time of the refresh.

Anonymous
Not applicable

Re: How to add Dataset's Last Refresh Date on your Power BI report.

Thanks for you quick response. My report is based on direct query, so I won't be able to create Blank Query. What do you suggest for this?

 

 

ssugar Member
Member

Re: How to add Dataset's Last Refresh Date on your Power BI report.

If it's directquery, then you could just create a new DAX measure:

Last Refresh = UTCNOW()

Anonymous
Not applicable

Re: How to add Dataset's Last Refresh Date on your Power BI report.

UTCNOW() displays current UTC timing, whenever we open the report. But whenever a report is opened that does not mean dataset is refreshed. So I want to show last refresh time from dataset, which is shown below.

Capture.JPG

ssugar Member
Member

Re: How to add Dataset's Last Refresh Date on your Power BI report.

If you're in directquery mode, anytime you open the report in the Power BI service the query is refreshed

 

From: https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about

"When opening an existing report in the Power BI service, or authoring a new one, the underlying data source is again queried to retrieve the necessary data."

Microsoft v-cherch-msft
Microsoft

Re: How to add Dataset's Last Refresh Date on your Power BI report.

Hi @Anonymous

 

Below is the similar post for your reference.

https://community.powerbi.com/t5/Desktop/Visual-element-with-timestamp-for-last-data-update/td-p/112418

 

Regards,

Cherie

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
avnish319 Visitor
Visitor

Re: How to add Dataset's Last Refresh Date on your Power BI report.

We can use the following to Adjust the timezone:

let
Source = DateTimeZone.SwitchZone(DateTimeZone.FixedUtcNow(),-5)
in
Source

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors