Is there an easy way to check which reports are used in a model and which can be removed?

[Bo_Suto]

Hello,

A while back I created a Power BI report using a lot of different excel spreadsheets. 

I kept expanding and changing the BI report based on new or updated requirements. At the moment the report has over 10 pages and various visualizations, tables, filters, etc. per page.

I'd like to tidy up the model in Power BI desktop and check if there are some spreadsheets I can remove from it as they are not being used any longer. Is there an easy way to check this? Also, I'm not using an API due to system limitations, so it is a manual update, i.e. I download all excel spreadsheets from various sources and then refresh the Power BI report.

Thanks, 

Bo

[v-yiruan-msft]

Hi @Bo_Suto ,

Please review the following links and check if they can help you.

Identifying unused tables,measure and columns - DAX / DAX Calculations - Enterprise DNA Forum

How to identify unused objects in Power BI | UMT Software

Best Regards