Forum Discussion

Koritala's avatar
Koritala
Post Patron
6 months ago
Solved

Data Filter Scenario

Hi All, I have a doubt and want to get the clarification on below scenario. I have a product table in power bi desktop and it is in import mode. I have created start and end date parameters in powe...
Need Help
  • cengizhanarslan's avatar
    cengizhanarslan
    6 months ago

    In Power Query, right-click the step where you applied the date filter. If “View Native Query” is enabled, the filter is pushed to the source. If it’s disabled, Power BI pulls all rows first, filter happens after load (no performance benefit).

QuentinGa's avatar
QuentinGa
Resolver I
6 months ago

Hi Koritala,

It depends on whether Power BI can “push” your date filter back to the data source (often called query folding).​


- If it can push the filter: only the rows within your Start/End date range are imported, so refresh is faster and the model is smaller.​

- If it can't: Power BI may load a much larger amount of data first, then filter it afterwards in Power Query, so you get little or no performance benefit.
​

Quick check: in Power Query, right‑click the step where you applied the date filter → if “View Native Query” is available, the filter is being pushed to the source, if it’s greyed out, it isn’t.

More info here: Query Folding 

Please leave a Kudo if it helps!

​