View Native Query getting disable after applying custom filters to the field in table

[Vaishali04]

Hi All,

When am applying parameter filter in custom filter in a field. "View" Native Query" is getting disabled after that step in Power Query. Due to which  while applying incremental load at UI it throws an error saying M query folding disabled. And if I remove custom filter from field in Power query than on defining incremental load it throws an error saying Parameters are not declared.

Does anyone has solution for this? Please help

Regards

Vaishali

[v-juanli-msft]

Hi @Vaishali04 

Is the parameter "start date" or "end date" parameter as refered in the incremental refresh configuration?

Best Regards

Maggie

[Vaishali04]

Hi @v-juanli-msft 

I am using RangeStart and RangeEnd parameters in custom filter.

Regards

Vaishali

[artemus]

Yes, based on your data source type (like SQL), some operations may not be supported as they aren't translated into the native query. In some cases alternatives can be used. This is much more likely with custom filters.

Maybe if you post your filter and data source type, we can help further.

[Vaishali04]

Hi @artemus 

I am making odbc connect in Power BI Desktop  using ODBC Driver 17 for SQL server with Azure Active Directory Password Authentication 

Regards

Vaishali

[v-juanli-msft]

Hi @Vaishali04 

Are your parameters and "date" column both date/time type?

If one is date type and another is date/time type, it won't work well for incremental refresh.

Please check if any step in your M query prevents the query folding.

You can refer to a  similar thread.

https://community.powerbi.com/t5/Desktop/Query-Folding-amp-Incremental-Refresh/td-p/957917

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.