Show data (tables and fields) used in report

[Anonymous]

Hello,

I have a report with a large data-model behind it and I know that I don't use all tables and I don't use all fields within the tables I actually use.

Because there's a performance issue I'd like to remove the unused tables and remove the unused fields within the tables I used.

Is there any way to track what tables are used in the report and furthermore what fields are being used?

Thank you 🙂

[amitchandak · Accepted solution]

@Anonymous , refer if this can help

https://www.umtsoftware.com/blog/how-to-identify-not-used-objects-in-power-bi/

you need external tools

or

install DAXSTUDIO, once intalled try following these steps:
Launch your powerbi report
Launch DAXSTUDIO and select your model
Run this query
SELECT * FROM $System.DBSCHEMA_TABLES WHERE TABLE_TYPE='SYSTEM TABLE'

[Anonymous]

Thank you!

I will try that 🙂