Forum Discussion

274188A's avatar
274188A
Advocate I
1 year ago
Solved

Surplus Tables

Hi, is there any recommended method to establish whether or not a Table is used by any visual,slicer or anything?  Just trying to tidy up a big mess I inherited and trying to identify unused tables. ...
Tips and Tricks
  • v-saisrao-msft's avatar
    v-saisrao-msft
    1 year ago

    Hi 274188A,

    Thank you for reaching out to the Microsoft Fabric Forum Community.

     

    Currently, there’s no automated way to detect if a table is used in visuals, slicers, or filters tools like Tabular Editor only check the data model, not the report layer. So the only reliable method is to manually check all visuals and filters.

    To improve this, you can suggest or upvote a feature on the Power BI Ideas forum here:
    Fabric Ideas - Microsoft Fabric Community

     

    Thank you.

pankajnamekar25's avatar
pankajnamekar25
Super User
1 year ago

Hello 274188A 

 

There are many ways

 Use DAX Studio with VertiPaq Analyzer to check table size and usage

 Use Tabular Editor to find references using "Find in Model"

Run C# script in Tabular Editor to identify unreferenced tables

  Manually hide table in Power BI and test report functionality

Check for tables without relationships in Model View

 Run DMV query (DISCOVER_CALC_DEPENDENCY) in DAX Studio

 Back up your .pbix before deleting any table

 Delete one table at a time and validate visuals and measures

 

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.