Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 🙂
Solved! Go to Solution.
@Xilitor01 , 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'
@Xilitor01 , 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'
Thank you!
I will try that 🙂
User | Count |
---|---|
107 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |