Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Hi @Vaishali04
Is the parameter "start date" or "end date" parameter as refered in the incremental refresh configuration?
Best Regards
Maggie
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.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |