Forum Discussion
API - activityevents scheduled refresh
Hi i got a question. I need to visualize and load the refresh history on our tenant. When I use the activityevents API it only returns OnDemand and ViaApi refresh. The scheduled refresh are not returned. But when i check on previous month (august) i see it. Did Microsoft changed the API? Is it a known bug?
4 Replies
For more information, the last day I can visualize the Scheduled refresh in the API is the september 1st.
Best regards
Hi jbouvet
The Activity Event API only gets you all events that have been done by users at some point. The scheduled refresh that you see in the Activity Event extraction is the event that a user had done/planned on September 1st.
To get the scheduled refresh for a dataset you need to use this API
https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-refresh-schedule
Hi jbouvet ,
Is there an error message in the refresh history? Are the credentials grayed out in the dataset settings?Could you please share more screenshots about the error?
How to Get Your Question Answered Quickly
Please provide more details with the error.
Best Regards
Community Support Team _ RongtieIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
https://learn.microsoft.com/en-us/rest/api/power-bi/admin/get-refreshable-for-capacity
I noticed as well the activity events api is only showing user events. It also does not show the amount of time that a refresh took to complete, I would advice to take the admin api to collect this info.
but if this is everything needed, you can also have a look at the fabric capacity metrics report.
https://learn.microsoft.com/en-us/rest/api/power-bi/admin/get-refreshable-for-capacity
The joy of this app is that it has a dataset attached to it which you can query as well so even when it is direct query partly getting data out of it and bring it to some other place for longer historic measures is possible.
With this all I have to remind that it takes a while before all logging is in that dataset. So if you directly want to see what is going wrong.. I still ask the activity api and watch all schedules to be able to cancel the right refreshes or notify users of extensive usage.
