topic Re: Admin API Activity Log - Dataset Refreshes in Developer

Admin API Activity Log - Dataset Refreshes

LeifB — Fri, 23 Feb 2024 19:36:08 GMT

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!

Re: Admin API Activity Log - Dataset Refreshes

lbendlin — Sat, 24 Feb 2024 02:23:24 GMT

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.

Re: Admin API Activity Log - Dataset Refreshes

LeifB — Mon, 26 Feb 2024 13:55:22 GMT

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.

Re: Admin API Activity Log - Dataset Refreshes

lbendlin — Mon, 26 Feb 2024 14:09:19 GMT

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 ?

Re: Admin API Activity Log - Dataset Refreshes

LeifB — Mon, 26 Feb 2024 14:27:46 GMT

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.