cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tteeple Frequent Visitor
Frequent Visitor

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.

12 REPLIES 12
Moderator v-qiuyu-msft
Moderator

Re: SSAS dimension visible with Visible property set to False

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
tteeple Frequent Visitor
Frequent Visitor

Re: SSAS dimension visible with Visible property set to False

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

E1AOouw

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.

hHmcyWA

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

Moderator v-qiuyu-msft
Moderator

Re: SSAS dimension visible with Visible property set to False

Hi @tteeple,

 

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

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Moderator v-qiuyu-msft
Moderator

Re: SSAS dimension visible with Visible property set to False

Hi @tteeple,

 

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.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
tteeple Frequent Visitor
Frequent Visitor

Re: SSAS dimension visible with Visible property set to False

Thanks @v-qiuyu-msft.  Can you provide me with a link of where to submit a support ticket?  I don't see anything on the SQL Server page for tickets.

kwilliams Frequent Visitor
Frequent Visitor

Re: SSAS dimension visible with Visible property set to False

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

 

Thank you

Moderator v-qiuyu-msft
Moderator

Re: SSAS dimension visible with Visible property set to False

@tteeple See: What is the procedure to open a ticket for microsoft??

 

@kwilliams In my environment, the issue also happens to SSAS 2016.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
sriniwas Frequent Visitor
Frequent Visitor

Re: SSAS dimension visible with Visible property set to False

Hi @v-qiuyu-MSFT ,

 

I am also facing the same issue what ever @tteeple, is getting.

 

@tteeple do you have any solution.if you have can you please share the information.

sriniwas Frequent Visitor
Frequent Visitor

Re: SSAS dimension visible with Visible property set to False

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.

 

Thanks,

Srini.