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
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.
Is the parameter "start date" or "end date" parameter as refered in the incremental refresh configuration?
I am making odbc connect in Power BI Desktop using ODBC Driver 17 for SQL server with Azure Active Directory Password Authentication
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.
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.