cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

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
Helper I
Helper I

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
Helper I
Helper I

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
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Top Solution Authors
Top Kudoed Authors