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,
What storage mode are you using? Import, DirectLake, or DIrectQuery?
If you're using Import mode, then you can filter the data in Power Query in the "Transform Data" window.
If you're using DIrectLake or DirectQuery it gets more complicated.
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
Yeah I'm using DirectLake. I just receive information that user also want to filter date range outside 30 last day so this step is not necessary now, but I still want to know how to do it with DirectLake mode
Hi minhnhatdanchoi,
With DirectLake mode, you will need to ensure your tables only have 30 days of data in them. In your ETL that loads data into your lakehouse/warehouse, add a step that takes the last 30 days of data and inserts it into a new table, and then source your report on that new table.
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.