Explore the meaning of the VertiPaq Analyzer metrics provided in DAX Studio. How to learn DAX: www.sqlbi.com/... DAX Studio: daxstudio.org/ VertiPaq Analyzer: www.sqlbi.com/...
Small video, just about 4 minutes, worth A lot to obtain! Good one Marco and keep going with those good videos 👍
@genaugenaugenau
4 жыл бұрын
You are a genius. Thanks for all this.
@petergolovatyi2447
4 жыл бұрын
Cool! Thank you for the explanation!
@PicaPauDiablo1
3 жыл бұрын
So much thanks!
@amarnadhg6896
4 жыл бұрын
Informative
@raulvera705
3 жыл бұрын
Thank you Marco & Alberto for all your videos! they are great! just 1 question, in my fact table I have a column with text format wich is the heavier in my model! how could i optimize this column to do my power Bi file lighter?! thanks a lot in advance!!
@SQLBI
3 жыл бұрын
The best option is to remove the column and retrieve the same data in other ways. For example, create a composite model keeping that data in a separate table, or create other reports to retrieve that information. Another alternative is to truncate the text and load a shorter version. Because the data has to stay in memory, keeping data that is rarely used is particularly expensive.
@nathanymiguel
3 жыл бұрын
Hi there, thanks a lot for the explanation. What is the meaning of the metric "Hier Size"?
@marcorusso7472
3 жыл бұрын
It's "Hierarchies Size", whereas "User Hier Size" is "User Hierarchies Size". These former is like an index containing all the values of the column sorted according to the required sort order (you can change it by using "Sort by Column". The latter is an index for the user hierarchies you create using two or more attributes. Both structures are used for MDX queries and partially by DAX as search index in columns.
@nathanymiguel
3 жыл бұрын
@@marcorusso7472 great, thank you for the clarification!
Пікірлер: 10