Hide/Unhide Columns issue: PBI Unhides hidden columns after pbix refresh
Submitted byAnonymouson12-07-202101:00 AM
In my pbix I hid all the columns and measures that are not neccessary for the users who may work with the excel analyzer or could connect to the dataset. The pbix was linked to our Dev database. When I switched the Parameter so that the pbix gets data from the Production database, the pbix got refreshed and the hidden columns got visible.
Interestingly enough, Measures and Calculated columns stayed hidden. Other (raw) columns got unhidden. Also, if a whole Table was hidden, it stayed hidden. If only some columns of a table were hidden then they got visible.