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,
Can you provide some more details? How big is your dataset, are we talking millions of rows or hundreds of millions?
What size capacity are you using?
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
Environment & scale
Lakehouse: ~20 tables total.
Fact tables: 5 fact tables that receive new data daily.
Ingest rate: ~100,000 new rows per day (total across facts).
Historical size: tables contain data from July → each table ≈ 50 million rows.
Semantic models: using Direct Lake mode.
Dashboards: slicer/filter targets the most recent 1 month of data.
Capacity: currently on F4.
Your semantic model and visual queries are trying to use ~8.5 GB RAM, but F4 capacity allows ~3 GB per dataset/operation.
This typically happens with Direct Lake mode, especially when:
The model is not optimized (wide tables, large cardinality columns).
Visuals trigger complex or large DAX queries.
Multiple visuals load at once with large context filters
Hi minhnhatdanchoi,
Do your visuals run on all the data in these tables? Are you able to limit what you bring into the report to just the recent records?
If you limit the data at ingest time rather than using a filter, the VertiPaq engine won't need to try and process 50 million records every interaction.
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
I need to know how can I limit the data at the ingest time rather than using a filter. I'm kind of new to PowerBI 😅
