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.

MasonMA's avatar
MasonMA
Super User
1 year ago

Hi pankajnamekar25 , i'm not sure if this answered 274188A's specific question. I've been wondering the same for some time and just tried running a C# script in Tabular Editor with your advise. but the problem is this doesn't catch visuals/slicers from the report canvas using the table, Tabular Editor can’t read the report layer of the PBIX, only the data model. Could you be spefic how to identify these unused tables? I normally just click the Visuals or go through the Filter pane one by one to identify which tables are not being used, which is time consuming..

 

thanks

 

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

Yes exactly, just checking for zero relationships has caught me out already!

As far as I can tell there is in fact no answer to this problem.  Time for a suggestions I guess...