Last Report refresh date VS last Dataset refresh planned date (success)

[AgoZ_KH]

Hi to all community!

I have read many articles about the way to solve the problem how to show in a report the last refresh date. And of course this functions well. The only problem is that that Date/Time is the refresh datestamp of a pBI service pubblished report.

What I need is the datestamp of the scheduled dataset refresh. I have read some articles about how to obtain the refresh history of a dataset using RESTAPI method. But -If i haven't misunderstood the problem- for use the API's the user must be a PRO powerBI user.

So if this is the requisite must to have, how to access at the desired information (last date/time of the scheduled dataset refresh) in a way that can used for a not PRO pBI user ?? Exist a different way to achive the desidered issue? Have any guys a solution for thi issue??

Thanks in advance for every suggestions!

AgoZ

[CatchAnalyst]

Hi everyone, i have the same request. The power report refresh stamp is great, but i need one for the dataset so my users know how current the data is when they are looking at the dashboard in Power BI Service.

Any help would be great

[Migasuke]

Hi @AgoZ_KH ,
If I uderstand well - you would like to see last refresh in PBI Service, but the time is showed based on PBI server. Because of that, you would like to try other path with API. Is that correct?

If yes, then you can easily use function in PQ of DateTimeZone.UtcNow(). You can create for example simple column with this date and based on this column create a dynamic tile in your report. Advantage of this functin is, that it will always show the UTC time, and eventually you can move it to your wished time zone (I think function DateTimeZone.SwitchZone is the right).

Let me know, if that helps.

[AgoZ_KH]

Hi @Migasuke ! Thanks for the reply and Yes this is what I want to obtain: the date and hour of the schedule refresh of the dataset (in my case every day at 05:00 AM).

I tried actualy to use PQ with this query:  =DateTimeZone.SwitchZone(DateTimeZone.FixedUtcNow(),+2); but the risult is that when I access from the link of the pBI service instead of the date/time equal to 05:14:44 I see 16:07:41.

But now I have the doubt that this IS the real last refresh date/time for the report for a on demand refresh operation made by the pBI desktop! I'm a little in confusion on the issue!! 🤔

Agoz

[Migasuke · Accepted solution]

Hi @AgoZ_KH ,

You should not use FixedUtcNow (as described in documentation:
Returns the current date and time in UTC (the GMT timezone). This value is fixed and will not change with successive calls.)

I ve just tested following Query in PBI Service and works perfectly (you can simply copy paste it):

let
    Source = DateTimeZone.UtcNow(),
    #"Converted to Table" = #table(1, {{Source}}),
    #"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "UTC Now"}}),
    #"Added Custom" = Table.AddColumn(#"Renamed Columns", "UTC +2", each DateTimeZone.SwitchZone([UTC Now],+2))
in
    #"Added Custom"

The standard DateTimeZone.UtcNow() should solve your problem.
 

[ebeery]

@AgoZ_KH I think this can be accomplished using Power Query.  I've seen the approach used in several places.

Here's one article with an example:

https://blog.enterprisedna.co/show-last-refresh-date-time-in-your-power-bi-reports/

[AgoZ_KH]

Hi @ebeery   thanks for the quckly replay! I have seen the article (and others) that resolve the problem using power query with an empty query. But the solution is not sutisfacting for me. Because the date/hour is about the refresh of the report on the report service side, that is not equal at the date/time of the refresh scheduled dataset. In my case I have scheduled the data refresh every day at 5 am, but if I use the method above the timestamp on the report is equal at the last access to report (i.e. 16:50 pm).

I need another solution to achive my goal!

Have a nice day!

AgoZ

[TonyMeng]

Hi AgoZ,

Do you get any solution for your goal?

[TonyMeng]

Have a same request, need the last refresh date of dataset, not last refersh date of report