cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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

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

 

 

5 REPLIES 5
Highlighted
Microsoft
Microsoft

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

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.

Highlighted
Community Support
Community Support

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

Hi @Vaishali04 

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

 

Best Regards

Maggie

Highlighted
Frequent Visitor

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

Hi @v-juanli-msft 

 

I am using RangeStart and RangeEnd parameters in custom filter.

 

Regards

Vaishali

Highlighted
Frequent Visitor

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

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

Highlighted
Community Support
Community Support

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

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.

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors