Native Query for Incremental Refresh

[powerbiexpert22]

i am trying to filter data only for year 2023 during import however native query option is not enabled as shown below

i want to enable native query option for incremental refresh

is there a way to enable native query while fetching rows for only 2023?

[Ritaf1983 · Accepted solution]

Hi @powerbiexpert22 
The easiest way is to create a view in SQL SERVER that is already filtered and use this view as a data source.
There are other workarounds to fix query folding in Power BI, but in my opinion, they are much more complex.

You can take a look at the linked videos :
https://www.youtube.com/watch?v=8hjdOCni_ZY

https://www.youtube.com/watch?v=xEhZuPk1EpA

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.