Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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 ,
what you're experiencing is likely related to backend changes or telemetry adjustments within Microsoft’s service. Since the GetUnusedArtifactsAsAdmin REST API is still in preview, Microsoft may modify the underlying logic or data sources without publicly announcing these changes.
A sudden drop from around 6000 to 100 unused datasets suggests that either the criteria for determining "unused" datasets have been refined—possibly considering additional signals like recent queries, service health pings, or refresh attempts—or there may be temporary inconsistencies in the usage telemetry that the API depends on. Given that your scripts and environment have remained unchanged, it's unlikely the issue originates on your side. Unfortunately, since the API relies on internal service data that isn't fully exposed, it's challenging to troubleshoot independently.
I recommend opening a Microsoft Fabric support ticket to check if any recent updates have impacted the API behavior. Additionally, you could manually validate a few datasets by reviewing their refresh history, audit logs, or activity logs to better understand which datasets are being excluded and why. Hopefully, as the API matures toward general availability, Microsoft will offer more transparency and stability.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
34 | |
21 | |
20 | |
14 | |
12 |
User | Count |
---|---|
26 | |
18 | |
18 | |
16 | |
14 |