Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Uniqueusername
Helper II
Helper II

How to add gateway refresh date and time to published report

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!

1 REPLY 1
lbendlin
Super User
Super User

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)

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!