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
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