Forum Discussion
How to optimize semantic model
Hi minhnhatdanchoi ,
Consider the GYC video as starter: Reframe your Power BI Direct Lake Semantic Model
and check the post as well
Solved: Re: How to do incremental refresh using datalake o... - Microsoft Fabric Community
If this response was helpful in any way, I’d gladly accept a 👍much like the joy of seeing a DAX measure work first time without needing another FILTER.
Please mark it as the correct solution. It helps other community members find their way faster (and saves them from another endless loop 🌀.
Hi minhnhatdanchoi ,
If I were you, I would do the following.
You basically have two options: either increase the Fabric capacity or optimize your data model.
Without knowing your data model, it is of course difficult to make recommendations.
But this is what I would do, or rather, how I would proceed.
- Check with the Metrics app, as already mentioned
- Use DAX Studio to identify large tables and columns. You probably already know most of this.
- Create aggregations. This should allow you to achieve the greatest memory reduction.
- Remove history from the model.
So my recommendation is that you should revise your data model. You should also consider whether Direct Lake is the right choice, as unfortunately it is not always suitable.
In the long term, you will probably need to increase your Fabric capacity.
You could also use the Fabric Estimator. It's still in preview, but it gives some good pointers.
https://www.microsoft.com/en-us/microsoft-fabric/capacity-estimator
I hope I was able to help you a little.
Best regards