Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Solved! Go to 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 ?
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.
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.
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 ?
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.
User | Count |
---|---|
5 | |
5 | |
3 | |
2 | |
2 |
User | Count |
---|---|
10 | |
7 | |
5 | |
4 | |
4 |