Can I check gateway refresh queue?

[redhill]

Hi. I have a lot of reports on same gateway. Sometimes, one report of them waits really long time but didn't get timeout. I think those reports in the refresh queue. Can I check gateway refresh queue for example right now? Which one is refreshing now, and which one will refresh next? and next... Like playlist maybe 🙂 

[ibarrau · Accepted solution]

Hi. You can't check that on the gateway. The gateway won't store any information about all the things it is refreshing. The schedule refresh is something stored at datasets info. It is like that because you can have datasets without gateway, so that can be checked only for datasets.

As an approach, you can build a dataset getting data from PBI Rest API in order to store data keeping datasets with gateway and their schedules.

You can start getting datasets filtering by gateway required: https://learn.microsoft.com/en-us/rest/api/power-bi/admin/datasets-get-datasets-as-admin

Then get refresh schedule for each dataset: https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-refresh-schedule-in-group

Transform and clean the data and you will have a dataset with the timelines of all datasets using gateways.

I hope that helps,

P/D you can use libraries to read API easier like SimplePBI for python.