The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello,
We are using this REAST API: GetUnusedArtifactsAsAdmin (https://learn.microsoft.com/en-us/rest/api/power-bi/admin/groups-get-unused-artifacts-as-admin) for getting unused datasets.
We have witnessed a sudden drop between the numbers we obtained in April (around 6000 datasets) and the end of May (around 100). We didn't conduct any cleanup in the meantime and our ps script didn't change, they don't throw any errors either. Has any of you experienced a similar problem? Do you know if something was changed in the REST API? Maybe criteria? I believe unused was 'not refreshed, not even with a failure' and 'not queried". Or maybe there is a bug, like problems with storing / collecting data by MS on the usage of datasets? I haven't found anything on the subject of this REST API in Power BI blog.
Unfortunately this REST API been in preview status for a few years now.
If it wasn't a problem with rest api, maybe you have an idea what could have happened with data? Or how we could try checking it.
Thank you in advance or your help
Solved! Go to Solution.
Hi @Trish_Rye,
Thank you @tharunkumarRTK @rohit1991 @BhavinVyas3003, for you valuable insights.
Please raise a support ticket so that the backend engineer can assist you in rectifying the issue. Below is the link to raise the support ticket:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
Thank you.
Hi @Trish_Rye,
Could you please confirm if the issue was resolved after raising a support case? If so, we’d appreciate it if you could share the solution to help others in the community. As we haven’t heard back, we’re closing this thread. For any further issues, please raise a new thread in the Microsoft Fabric Community Forum — we’ll be happy to assist.
Thank you for being part of the Microsoft Fabric Community.
Hi @Trish_Rye,
Thank you @tharunkumarRTK @rohit1991 @BhavinVyas3003, for you valuable insights.
Please raise a support ticket so that the backend engineer can assist you in rectifying the issue. Below is the link to raise the support ticket:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
Thank you.
API documentation does not indicate any change, Not sure if Microsoft has done any change from their end.
As @rohit1991 suggested, you can log a microsoft support ticket and get help from them.
Meanwhile if you want to investigate on your own, I would suggest you to extract the audit events of last 30 days
https://learn.microsoft.com/en-us/rest/api/power-bi/admin/get-activity-events
and then check if there any activities which could be the reason for this
Connect on LinkedIn
|
Hi @Trish_Rye
A drop from ~6000 >> ~100 usually means the backend telemetry/criteria for “unused” shifted (any recent view/query/refresh now counts as “used”), not that your script broke.
Sanity checks
Confirm the caller still has admin/SPN visibility to all workspaces (incl. new Fabric workspaces/capacities).
Cross-check with Admin Activity Events (last 60–90 days) for ExecuteQuery, ViewReport, Refresh by DatasetId.
Spot-check a few workspaces: compare this API vs. refresh history + activity events.
Run on smaller scopes to rule out throttling/sampling.
If the counts still don’t line up, it’s likely a preview regression >> open a Microsoft support ticket with sample DatasetIds and timestamps.