Forum Discussion
The Incremental Refresh Date Filter using RangeStart & RangeEnd Parameters not working as expected
Hi MangeshVC
The issue might be caused by incorrect query folding or mismatched data types. Here's how to resolve it:
Right-click in Power Query on the applied steps and ensure the "View Native Query" option is enabled. If not, the query is not folding properly.
Ensure the column you are filtering (DateTime) is set to the correct Date/Time data type in Power Query.
Reapply the RangeStart and RangeEnd filters on the DateTime column explicitly in Power Query.
If the ID column is calculated or used indirectly, it may interfere with query folding. Ensure the filtering is directly on the date column.
Verify that the M code applies filters directly to the DateTime column using RangeStart andRangeEnd. Adjust if needed.
If the issue persists, the source query (SQL Server) might require optimization to support proper query folding.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂
Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Please Subscribe my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS
Hi MangeshVC
The issue might be caused by incorrect query folding or mismatched data types. Here's how to resolve it:
Right-click in Power Query on the applied steps and ensure the "View Native Query" option is enabled. If not, the query is not folding properly.
Ensure the column you are filtering (DateTime) is set to the correct Date/Time data type in Power Query.
Reapply the RangeStart and RangeEnd filters on the DateTime column explicitly in Power Query.
If the ID column is calculated or used indirectly, it may interfere with query folding. Ensure the filtering is directly on the date column.
Verify that the M code applies filters directly to the DateTime column using RangeStart andRangeEnd. Adjust if needed.
If the issue persists, the source query (SQL Server) might require optimization to support proper query folding.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂
Kind Regards,
Poojara
Data Analyst | MSBI Developer | Power BI Consultant
Please Subscribe my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS