How to add gateway refresh date and time to published report

[Uniqueusername]

Hi,

I have a few semantic models and associated reports published on a premium workspace. There is an enterprise gateway attached the datasource (SQL DB)  using which the report refreshes are set to occur at a particular time. The refresh times are set at different times of the day but they can occur anytime between 1am-6am to reduce the load

Now, is there a way to add the gateway refresh times as a visual in the published power bi report. Just to clarify, I am not looking for the time the model in the PBIX report is refreshed (which is easy enough to do). I need the time the gateway refresh got triggered that morning

Thanks!

[lbendlin]

the report refreshes 

Reports don't refresh. Semantic models refresh.  Reports render.

What's the business value?  

You would need to use a call against the Power BI REST API to fetch the $top=1 refresh history for that semantic model.

Datasets - Get Refresh History In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

The fact that a gateway is involved is slightly irrelevant  (and non-deterministic as any of the gateway cluster members could have served the request).  If you need gateway details you would need to grab the Activity ID from the refresh and then parse the gateway logs for that.  (Fun fact: gateway logs are only flushed to disk every 24 hrs)