Forum Discussion
Native Query for Incremental Refresh
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?
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_ZYhttps://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.
1 Reply
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_ZYhttps://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.