cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
qsong
Helper II
Helper II

Report dataset ending refreshing time PowerBI

Hi Community

 

I am wondering if we can report the ending refreshing time in the powerBI report. I checked the forum and it has some useful tips to add last refreshing time (starting refreshing time) in the report. However, I need my clients to know if the report is refreshed, so the ending dataset refreshing time provides more info for my case.

 

qsong_0-1607461619974.png

 

 

Thank you for any comments

 

Best, Qianru

3 REPLIES 3
mahoneypat
Super User IV
Super User IV

I would just use the DAX table with {NOW()} instead as it will calculate after your queries I believe.  But here is one way to add it into your M.

 

let
TodaysDate = DateTimeZone.FixedUtcNow(),
#"Converted to Table" = #table(1, {{TodaysDate}}),
#"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "Last Refresh Date Time"}}),
#"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Last Refresh Date Time", type datetimezone}})
in
if Table.RowCount(otherqueryname)>0 then #"Changed Type" else null

 

Regards,

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


mahoneypat
Super User IV
Super User IV

You can use an if that calculates after your longest query to get close to that.  Or you can just make a DAX table with the NOW() function, so it recalculates after the queries load.

 

RefreshTable = {NOW()}

 

let

Source = if Table.RowCount(longestquery)>0, Date.From(DateTime.LocalNow()), null)

in

Source

 

Regards,

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


@mahoneypat 

 

This is my current query in advanced query to get starting refreshing time:

 

let
TodaysDate = DateTimeZone.FixedUtcNow(),
#"Converted to Table" = #table(1, {{TodaysDate}}),
#"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "Last Refresh Date Time"}}),
#"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"Last Refresh Date Time", type datetimezone}})
in
#"Changed Type"

 

Where will you add if? Thank you for your details.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors