Forum Discussion
Resolver IPBI Premium Crashes
Hi everyone.
I have a model that collapses all the premium capacity when at least 5 users use the report, I already reduced the memory capacity from 2.5 G to 0.9 G, I delete data columns, I used Surrugate Key the model went from 400 to 250 m rows, the size went from 1.2 G to 0.54 G, but it keeps collapsing, what else can it be?
Dear community.
After many sleepless nights, I saw the light, although Dax Studio, Bravo and Tabular Editor are basic and powerfull tools, I met Dax Opmitzer who allowed me to see which formulas were the ones that had to be corrected and it is very helpful, 100% recommended, the tool improved a lot... Greetings to everyone who responded to this post
13 Replies
- lbendlin
Super User
Even a P1 SKU should be able to handle that. Please describe what "collapses" looks like.
Khristianthe peaks of premium capacity reaches 300%
- lbendlin
ask the users what visual they looked at. Collect the DAX query for that visual. Examine it in DAX Studio and see if you can optimize the measures to reduce the cartesian .
- Khristian
"Is it possible that the use of matrices is the cause? I have 6 sheets, each with the same 11 measures. Each matrix has only one hierarchy, but each sheet has a different grouping field. Could that be the cause?"
- Khristian
well, the detail facttable has 250 m, i have severals of models even with more rows and more complex calculatacions, in this model when 5 users work in the model powerbi premium capacity reaches more than 300% of CPU capacity, then it could no be in production, i have re builded the model, complexity of the model and cardinality and columns has been deleteded, sacrifying functionality,but, it does not work, just if a model is gruoped it in sql at monthly level, all the functions works, i dont know what is happend, because i have to separate datamodels perhaps in 3 modes, montly, weekly and daily, and the user experience is affected, i dont know what is happend, if i used the model with pro licensed run smoothly, i undestand why, but it does not have sense, dax studio show me every thing is ok
Hi Khristian ,
Has your issue been resolved?If the response provided by lbendlin addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.
If yes, kindly accept the useful reply as a solution and give us Kudos. It would be appreciated.
Thank you for your understanding!- Khristian
no, it does not work, finally i create some tricks
- Khristian
Dear community.
After many sleepless nights, I saw the light, although Dax Studio, Bravo and Tabular Editor are basic and powerfull tools, I met Dax Opmitzer who allowed me to see which formulas were the ones that had to be corrected and it is very helpful, 100% recommended, the tool improved a lot... Greetings to everyone who responded to this post
Hi Khristian
Glad to know that your issue has been resolved!
If you need any further help or have more questions in the future, please feel free to reach out always happy to help.
Marking this as the solution so it can be helpful for others who might face a similar issue.Thank you.
