Solved: Native Query for Incremental Refresh

powerbiexpert22 · ‎07-15-2024

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 · ‎07-15-2024

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.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

Ritaf1983 · ‎07-15-2024

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.

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile