Admin API Activity Log - Dataset Refreshes

[LeifB]

We have been storing historical data from the Admin API Activity Log for quite some time, primarily for tracking report usage, and we've recently looked at the "RefreshDataset" activities (listed here) to show refresh history. However, this appears to only include On Demand or Via API refreshes, not scheduled refreshes. Is this expected? If so, is there a better way to retrieve dataset refresh details for all refresh types? Thanks in advance!

[lbendlin]

Use the Fabric Capacity Metrics App to get a near-real time view of semantic model and dataflow refreshes.

The limitation/blind spot is not on scheduled refreshes but on XMLA endpoint refreshes.

[LeifB]

Hi @lbendlin, we are looking for data on all our dataset refreshes, not just the datasets on our Premium Capacity, so the app does not provide the necessary info. We would also like to have more history than the 2 weeks that the app provides.

[lbendlin · Accepted solution]

There is the option to harvest the Refresh History details from each semantic model via the REST API but that is also limited to the last 20 refreshes. 

Are you attempting to audit refreshes on "My Workspace"  type of workspaces ?

[LeifB]

That may be what we're looking for, unfortunate that it is only the last 20 but it's a starting point. And no, we aren't trying to look at personal workspaces, we just have quite a few Pro workspaces that contain production datasets.