Getting Schedule Refresh time from all Reports/Workspaces in one shot

[dujos]

Hello all i need a little help about getting informations about Schedule Refresh times set on the reports. The point is i don't want to enter one by one to se the schedule refreshes times but is there some way to get this information for all reports/workspaces that i have access?

[Greg_Deckler · Accepted solution]

@dujos Check out the Power BI REST API

https://docs.microsoft.com/en-us/power-bi/developer/automation/rest-api-reference

[dujos]

Hello @Greg_Deckler thank you for your quick answer. I'm taking a look at the link that you sent to me to see how can i use it because i'm not familiar yet with APIs but i will try it if this can bring me the information about times scheduled on the reports it will help a lot. As i told we i don't want to enter one by one reports to get this information there is more then 300 reports and i can do that. So let me try with this REST API. Do you have a little example how to use it?

Thanks again!

[Greg_Deckler]

@dujos Specifically:

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getrefreshschedule

You can grab all of the datasets using:

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getdatasets

Then just iterate through them dumping their refresh schedules. Should be able to steal someone's Powershell code to do this I would think