Forum Discussion
Pk8524
1 year agoHelper I
Dax code optimization
I have issues with one of the charts I have created. When uploaded to powerbi service it exceeds allowed memory. Can you have a look at this: There are 15 categories. Each category has 10 m...
- 1 year ago
I would suggest you install DAX Studio, learn how to use it, and then use it to examine the query plans for your queries. Then you can decide how to refactor the queries to reduce cardinality, formula engine usage, RI violations etc.
lbendlin
1 year agoSuper User
How familiar are you with DAX Studio , Formula/Storage engine, and query plans?
- Pk85241 year agoHelper I
i am familiar with those concepts. Nor particularly with dax studio. What you have on your mind?
- lbendlin1 year agoSuper User
I would suggest you install DAX Studio, learn how to use it, and then use it to examine the query plans for your queries. Then you can decide how to refactor the queries to reduce cardinality, formula engine usage, RI violations etc.