Forum Discussion

Pk8524's avatar
Pk8524
Icon for Helper I rankHelper I
1 year ago
Solved

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...
  • lbendlin's avatar
    lbendlin
    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's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

How familiar are you with DAX Studio , Formula/Storage engine, and query plans?

Pk8524's avatar
Pk8524
Icon for Helper I rankHelper I
1 year ago

i am familiar with those concepts. Nor particularly with dax studio. What you have on your mind?

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    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.