Forum Discussion
Can I check gateway refresh queue?
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.
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.