Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hide columns reset to unhide when refreshing

Hello everyone,

 

i'm facing a weird problem. When refreshing data to my pbix file(with refresh button), all hidden columns becomes unhidden.

 

My data source is sql server and my power bi version is 2.88.1682.0 64-bit (December 2020)

 

I found this Solved: Hide tables resets to Unhidden with data refresh - Microsoft Power BI Community but didn't work..

 

Does anyone know how to solve this?

 

Thank you,

Artemis

Need Help

5 Replies

  • mattcarter865's avatar
    mattcarter865
    Icon for Helper I rankHelper I
    5 years ago

    I had this happen to me while working with a directquery data model. Every time I clicked refresh in PBI a lot of the columns that I had hidden became unhidden again. But not all of them. 

     

    I believe it was because I had hidden a majority of them using Tabular Editor and just altering the Hidden attribute to True. However, it looks like when you use PBI to hide a column it also adds an Annotation

     

    PBI_ChangedProperties - ["IsHidden"]

     

    With this value set, the hidden columns stay hidden after data refresh.

  • svenv's avatar
    svenv
    Frequent Visitor
    5 years ago

    Hi Matt and Artemis

     

    For the last few months I've experienced the same behaviour - hidden columns become unhidden.  This has happened over and over again in multiple PBIX files.  To make things more confusing, most but not all of the hidden columns become unhidden - in other words, for some reason some of the hidden columns have stayed hidden.

     

    I have hidden columns in both Tabular Editor and in Power BI and this has not made any difference.

     

    In addition, the "unhiding" action does not materialise consistently.   It is not that the columns unhide on a refresh, or a partial refresh, or a PQ "Close and Update", etc.  It is very sporadic.

     

    To make matters worse, the "autosums" are also coming back after they have been removed (also in both Tabular Editor and in Power BI).

     

    Both of these problems are very serious for us because we hide certain fields on purpose and now these changes are being lost, and we also intentionally use measures and not autosums.

     

    I'm determined to find the cause for these problems but I can't seem to find anything on the web, apart from this thread.

     

    Cheers
    Sven