Data Filter Scenario

[Koritala]

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 power query editor. After that I have applied the 2 date parameters on one of the date/time column that is called "product orderdate" by click on the column header and go to filter and applied the both parameters.

My question is, in this approach data will be filtered after all the product table data is loaded into memory or will it apply the date range filter before loading data in to model? 

Performance wise, is there any benifit in case of large volume tables if we follow this approach?

Thanks,

Srini.

[cengizhanarslan · Accepted solution]

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).

[Koritala]

Hi cengizhanarslan,

Thanks for your response. In my case query folding option is not enabling as my db is redshift.

Thanks,

Srini

[QuentinGa]

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!

​