Hide blank member SSAS does not work in Power BI

[VanThuan]

I’m using a Power BI report in Live Connection to a Tabular SSAS cube. The cube contains a ragged hierarchy and I have enabled the “Hide blank members” option. This works correctly when connecting from Excel, but Power BI still shows blank rows.
In excel

in Power BI

Could you please hep? 

thank you 

[v-kpoloju-msft]

Hi @VanThuan,

Thank you for reaching out to the Microsoft Fabric Community Forum. Also, thanks to @DanieleUgoCopp, for those inputs on this thread.

Has your issue been resolved? If the response provided by the community member @DanieleUgoCopp,  addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.

Thank you for using the Microsoft Community Forum.

[v-kpoloju-msft]

Hi @VanThuan,

Just wanted to follow up. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.

Thank you.

[DanieleUgoCopp · Accepted solution]

Hello,
I’ve seen this behavior before when using Power BI with a Live Connection to SSAS Tabular even if “Hide blank members” is enabled in the model and works as expected in Excel, Power BI seems to handle ragged hierarchies differently and still shows blank value, from what I understand, Power BI does not fully respect this SSAS setting in live connections.
One possible approach could be to handle the blanks directly in the SSAS model, for example by replacing null values or adjusting the hierarchy definition, although I’m not completely sure this will fully resolve it in Power BI.