Forum Discussion
Helper IVSSAS & Power BI vs memory failure
Hi Medmbchr ,
Of course you can through this way to optimize your dataset.
Optimization guide for Power BI - Power BI | Microsoft Learn
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Helper IVHi
I don't really have an idea about the size of the tables I have, all I can say is that the largest one contains about 60k of lines and about 30-40 columns, 35 tables in total.
How can I reduce memory allocation for SSAS?
Super UserAgain you cannot do that. It's not a SSAS issue. It's that your ram can't fit all the data in the PowerBi tabular model.
35 tables can be a lot for a single model. Are you sure 65k is the max row count of all of those tables?
You can always work with reduction tips to downsize your data model like: https://blog.ladataweb.com.ar/post/614108758904389632/datamodeling-5-tips-de-reducción-de-tamaño-de
There are many videos and posts about downsizing model with good practices.
Just in case. When the model is too big for your machine, you can develop with a technique of parameters. It's about reducing the data and working with samples of data. Then you can ask for the whole data once published.
I hope that helps,
P/D You can try refreshing the powerbi desktop in a different machine with more ram or less process using your ram and check if that one works.
- Medmbchr
Hi
Thanks for your reply
I have an idea, if I filter my whole data from Power Query (e.g. I take only 2022 data on all my tables for example), would that optimize my dataset somehow?
Hi Medmbchr ,
Of course you can through this way to optimize your dataset.
Optimization guide for Power BI - Power BI | Microsoft Learn
Best regards,
Community Support Team Selina zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly