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.
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.
Thank you for any comments
Best, Qianru
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |