Power BI/DAX and SSAS Multidimension are working together not respecting MembersWithData

[inayatkhan]

This not a bug in the Hierarchy Slicer but in Power BI , see the following information from Jan Pieter Posthuma the author of the slicer.  The MDX / Dax / Power BI is repeating the parent member in the child level below. 

This issue and it is not related to the HierarchySlicer, but how Power BI/DAX and SSAS Multidimension are working together.Somehow the MembersWithData set to NonLeafDataVisible (see: https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/parent-child-dimensio...)

is not respected and the child level is returned to Power BI.

It is related to PowerBI/DAX and SSAS MD. You may reference Jan Pieter Posthuma if more information is needed.

If we look at the following Parent-Child hierarchy in AdventureWorks you see that Brian is only visible  at level 03:

But if we retrieve the same hierarchy in Power BI with the HierarchySlicer and the OOB table we see that Brian is returned twice, level 03 and level 04.

[v-qiuyu-msft]

Hi @inayatkhan,

I have reported this issue internally: CRI 71613237.  Will update here once I get any information. 

Best Regards,
Qiuyun Yu

[v-qiuyu-msft]

Hi @inayatkhan,

This is a useful feature, called data member, of the multi-dimensional model. See the Data Members section of webpage https://docs.microsoft.com/en-us/sql/analysis-services/multidimensional-models/parent-child-dimensio....

Please change this setting on SSAS side:

Best Regards,
Qiuyun Yu

[inayatkhan]

Hi Quiyun Yu,

Thanks the setting was already set to NonLeafDataHidden but this made no difference to the behaviour of the data returned to the hierarchy slicer.  Parent member is still repeated on the child level

Regards

Inayat Khan

[Anonymous]

Do we know if there is an update on this bug? Or any work-around?

[stb88]

Hi, I am also having the exact same issue. Is there any update to this (CRI 71613237)? 

I've already set the NonDataLeafHidden for MembersWithData, however, the parent node is still repeated inside the child node when using the HierarchySlicer visual. In Excel, is fine.

Much appreciated if you could provide an update ASAP. Thank you.