Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 🙂
Solved! Go to 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.
Happy to help!
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.
Happy to help!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.