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.
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.
@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.
I can reproduce this issue. And I already reported it internally, will update here once get any feedback.
I got the information that dimension visibility is not reflected correctly in CSDL acquired from AS Engine. The incorrect CSDL is an AS Engine bug. And you should submit a support ticket to SQL support directly. Please notice that AS Engine bugs typically take longer to get fixed for users because of their slower release cycle.
@v-qiuyu-MSFT, is there particular versions of the AS enging this affects? I know it is a problem on 2014, but does it exist as well on 2016?
@kwilliams In my environment, the issue also happens to SSAS 2016.
Hi v@-qiuyu-MSFT ,
I am also facing the same issue what ever @tteeple facing the issue. while dimension visible property change to False.It is working fine in while connecting excel .But in powerbi it's not working.
@tteeple do have any solution. if you have can you please share the information.