Forum Discussion

tteeple's avatar
tteeple
Regular Visitor
9 years ago

SSAS dimension visible with Visible property set to False

I still see some dimensions that have their Visible property set to False in the cube.  The Dimension Usage tab shows False as well as the dimension on any perspectives.  It works for some dimensions while others, it still shows.  I am seeing this with the SSAS on premise live connection in Power BI Online and Desktop.

13 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    9 years ago

    Hi tteeple,

     

    When we connect to SSAS in desktop in live connection, all hierarchies and dimensions should be the same as on databased engine. I would suggest you check if dimension attributes visible on SSAS side firstly.

     

    In addition, based on my test, when we set the AttributeHierarchyVisible as False for the dimension attribute. If it's referenced in user-defined hierarchy, still be visible in hierarchy when we browse the cube.

     

    Best Regards,
    Qiuyun Yu

    • tteeple's avatar
      tteeple
      Regular Visitor
      9 years ago

      v-qiuyu-msft  Thanks for responding.  The issue is with the entire dimension, not just a single attribute.

      As you can see, I have the Visible property on the entire dimension in the Dimension Usage tab set to False.  The dimension still shows up in Power BI, both Online and Desktop, so it can't be a gateway issue.

      I have other dimensions set to False and they do not show up.

      • v-qiuyu-msft's avatar
        v-qiuyu-msft
        Icon for Community Support rankCommunity Support
        9 years ago

        Hi tteeple,

         

        I can reproduce this issue. And I already reported it internally, will update here once get any feedback.

         

        Best Regards,
        Qiuyun Yu

  • GianniB's avatar
    GianniB
    Frequent Visitor
    8 years ago

    Same issue if I set to False the visibility of only a hierarchy in a shared dimension (I need it visible only for some cubes). If it's a AS bug, why Excel correctly hides the hierarchy? I'm connecting to SSAS 2016

  • kronvi's avatar
    kronvi
    New Member
    8 years ago

    Hi,

     

    Maybe, it could be solved with the perspectives. I have done a test and it looks like it works

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Issue is still reproduced. Power BI Desktop version: 2.60.5169.4101 64-bit (July, 2018)

    SSAS Multidimentional version: 13.0.5026.0

    If dimension has a user-defined hierarchy, it is visible in PowerBI with Visible property set to False.

    If dimension doesn't have user-defined hierarchy, it is invisible in PowerBI when Visible=false.

    Using perspective is not an option for me.

    Does anyone know if a proper fix is going to be released any time soon?

  • cpassuel's avatar
    cpassuel
    Frequent Visitor
    6 years ago

    I have this issue since SSAS 2008 R2, it seems it's a very low priority for MS.

    The workaround is to delete the attribute and recreate it.