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,
Monitor memory usage using the Capacity Metrics App. If your semantic model needs more RAM, you may need to upgrade your capacity. To enhance performance, try reducing the dataset size and use model optimization methods like aggregations or DirectQuery for large tables. Power BI does not show memory usage for individual visuals or measures.
Thank you.
My semantic model already used Direct Lake, my table contains 5 millions rows