Forum Discussion

rdlhrvy's avatar
rdlhrvy
Helper I
2 years ago

Identify used columns with user personalization visual

I am trying to find out what columns are used with user personalization. 

 

Most of the software or 3rd party apps I found is only identify the used columns in the report and not what is the columns used with personalization with users. 

 

Does any one know a way to identify those columns?

8 Replies

  • aj1973's avatar
    aj1973
    Community Champion

    Hi rdlhrvy 

    I don't recall such thing is possible in Power BI ! even using Power BI REST APIs can't get you such info's

     

    • rdlhrvy's avatar
      rdlhrvy
      Helper I

      This would be a nice feature even using a 3rd party app to get rid of columns that is not totally used especially with hundreds of users and we can't figure out what really is not being used. It is hard to prove that they don't use it and remove the columns.  Users saying they using it but we don't have visibility they they really used it. It is just consuming space in the model especially with the table that has billions of rows.

      • aj1973's avatar
        aj1973
        Community Champion

        Well, what you are saying now is different. A column(field) that is not used or visited in a visual by the end user doesn't mean that the column is not necessary in the semantic model. Though to identify unnecessary columns in a semantic model you can use Tabular Editor or even better Bravo  https://bravo.bi/