PowerBI Audit Activity events API - Scheduled RefreshDataset activity

[ledd_25]

im trying to get refresh activity for all datasets in the organization using service principal utilizing the get activity events

However this does not include scheduled events. You can use get refresh history, but it only works for workspaces you have access to.

But im trying to get all the scheduled refresh events of all datasets in the organization. Are there other ways to access that without being part of every workspace?

if no, then  how could you get all scheduled refresh dataset activities of the org's datasets? Do you need to programmatically set yourself as a workspace user temporarily then remove when done?

[Deku]

You would need read access to the semantic models.

Alternatively you can set log analytics integration on each workspace. This will give all refreshes, plus you get the benefit of knowing how long the refreshes take and the cpu cost, plus you get stats for individual tables and partitions etc 

[ledd_25]

I have over 1000 workspaces, is there any way to programmatically do that? if no, what other alternatives do i have?

[Deku]

Yes. Use GetGroupsAsAdmin to get the workspace then run AddUserAsAdmin for each. Pick you favourite scripting language of choice