Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
powerbiexpert22
Post Partisan
Post Partisan

Unused Reports in Power BI

Is there a way to get the list of unused reports in Power BI? Report usage metrics report gives information at specific report level however i need consolidated list of all unused reports

1 ACCEPTED SOLUTION

@powerbiexpert22  You do require the following permission for this Rest API

 

Wikkleyn_81_0-1720689515580.png

 

View solution in original post

6 REPLIES 6
SaiTejaTalasila
Solution Sage
Solution Sage

Hi @powerbiexpert22 ,

 

You can contact your power bi tenant admin you can get the activity logs/Audit logs to identify the unused reports.

 

Thanks,

Sai Teja 

Wikkleyn_81
Resolver III
Resolver III

Hi @powerbiexpert22 There is a new Rest API that provides you with a list of unused artifacts.

https://learn.microsoft.com/en-us/rest/api/power-bi/admin/groups-get-unused-artifacts-as-admin 

 

You can specify the GroupID or use https://learn.microsoft.com/en-us/rest/api/power-bi/admin/groups-get-groups-as-admin to get a list of Group IDs and loop through to get the full list.

Hi @Wikkleyn_81 , 

do i need admin rights to call rest api?

@powerbiexpert22  You do require the following permission for this Rest API

 

Wikkleyn_81_0-1720689515580.png

 

mariussve1
Impactful Individual
Impactful Individual

Hi,

 

Then you need to look into ActivityEvent REST API.

You can then build a report across your tenant with years of history.

 

Im using Fabric pipeline to Get the data and storing it om Fabric Warehouse.

 

You can also use powershell or powerautomate or Something else lile notebook. If you have a data warehouse you can store the data there or you can store it on sharepoint, onedrive or Something at your choice. A lot of opportunities.

 

I also have a project now getting data from Log Analytics so I can see usage on page level in every report. This is much more complexe, but doable!

 

Br

Marius

Hi @mariussve1 ,

 

can we track this my using auditing feature?

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.