Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn 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 |
---|---|
94 | |
90 | |
79 | |
77 | |
71 |
User | Count |
---|---|
119 | |
105 | |
90 | |
64 | |
63 |