Forum Discussion
Koritala
6 months agoPost Patron
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...
- 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).
cengizhanarslan
6 months agoSuper User
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
6 months agoPost Patron
Hi cengizhanarslan,
Thanks for your response. In my case query folding option is not enabling as my db is redshift.
Thanks,
Srini