Forum Discussion
Solved
How to optimize semantic model
I encounter this ram issue when load my dashboard Error fetching data for this visualResource Governance: We cannot complete the requested operation because there isn't enough memory (consumed memor...
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 🌀.
My semantic model already used Direct Lake, my table contains 5 millions rows
Hi minhnhatdanchoi,
Key Best Practice
Filtering at ingestion or using aggregations is far more effective than relying on slicers because slicers still load the full dataset before applying filters.
Optimise the Semantic Model
- Remove unnecessary columns.
- Use aggregated tables for historical data (e.g., monthly summaries instead of raw rows).
- Avoid calculated columns on large tables; prefer measures.
- Consider incremental refresh with Direct Lake to keep only recent partitions active.