Exploring attribute hierarchies in Power BI and Analysis Services - Unplugged #31

Discover the pros and cons of disabling attribute hierarchies in Power BI and Analysis Services by modifying the "Available in MDX" property.
We will analyze the difference in memory and performance that you can obtain by modifying a Power BI model using Tabular Editor and DAX Studio.
Read more about the "unplugged" format: www.sqlbi.com/blog/marco/2021...
#unplugged

[@_-VAV-_]

Unplugged versions of videos are so good. Well done!

[@Milhouse77BS]

Another timely video for me. I've been using Best Practice Analyzer (BPA) in Tabular Editor to easily identify and disable columns isAvailableInMdx property. But now I will be more careful about disabling, and focus on larger size, and columns that won't be used in calculations. And I loved the #unplugged at 26:14.

[@johansantacruz6464]

Thanks for helping us to learn so much about DAX!

[@Cos_PB]

great insight, Marco! thanks for sharing.

[@zxccxz164]

Please discuss the impact oh processing large partitioned model. Currently it takes same time to process one partition as it does to process all 10 year partitions

[@AlbertoGastaldo]

Hi Marco, very interesting video !
What do you think about removing the hierarchy attribute from columns used in relationships ?
In my DWH u always use surrogate keys and establish relationships in the model through those columns.
Since all keys are identity columns, the hierarchy is quite large.
Thanks for your suggestion
Alberto

[@SQLBI]

No side effects if they are used only in relationships and not in formulas.

[@AlbertoGastaldo]

@@SQLBI Thanks ! I'll go through the columns removing che SK first, and test both RAM savings & performance.

[@kalinduSekara]

Thanks for the video Marco.
I thought tabular is running under the power bi, what is the business of 'MDX' In here?. Can you explain this.

[@SQLBI]

When you use "Analyze in Excel" the queries are generated in MDX by Excel.

[@kalinduSekara]

@@SQLBI thank you.