Anonymous's avatar
Anonymous
Not applicable
5 years ago
Status:
New

Hide columns reset to unhidden 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

5 Comments

  • v-chuncz-msft's avatar
    v-chuncz-msft
    Icon for Community Support rankCommunity Support

    Anonymous 

     

    I tried the latest version of Power BI Desktop to create a report but cannot reproduce the issue. Try to recreate the report.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hello v-chuncz-msft ,

     

    thank you for your response.

     

    I have created the report from scratch and everything were ok at the begining. After that i sent the pbix file to a customer, he made some changes and sent it back to me.

    After that i opened the new file, and the problem was still present. When refreshing the data, all hidden columns became unhidden.

    It is not practical to recreate a new report every day..

     

    Do you have any ideas?

     

    At your disposal for any further info,

    Artemis

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hello 

    Try to active this feature :

    regards 

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hello Anonymous ,

     

    Thank you very much for your response!

     

    After activating this feature, the problem was solved!

     

    Best regards,

    aandreou

  • rsrwebsupport's avatar
    rsrwebsupport
    Frequent Visitor

    I just ran into this issue today and I tried toggling that setting but it didn't fix the issue.  Is there anything else I have to do besides enabling the setting and re-publishing the dataset?

     

    EDIT: I opened a support ticket and they said this is an outstanding bug.