Incremental Refresh inside Power Query M DAX Query

Hi PImre ,
Hi PImre, when using a DAX query inside Power Query M to import data from an Analysis Services source, applying Incremental Refresh becomes more complex because Power BI's Incremental Refresh relies on native query folding to push date filters to the source system. Since you're manually writing a DAX query, Power BI may not recognize it as foldable or suitable for parameter-driven filtering required for Incremental Refresh setup. 

One workaround is to restructure your approach to use a native table import (without a custom DAX query) and apply the date filters using Power Query parameters (RangeStart and RangeEnd) so Power BI can detect and configure Incremental Refresh correctly. Alternatively, if you must use a DAX query, you could dynamically build the query using M code to inject the parameter values, though this requires careful handling and testing to ensure it supports refresh on the Power BI Service.