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 versio...
Need Help
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.