Can't change data source when using Value.NativeQuery

You don't need to use native query for incremental refresh. Query folding means powerquery steps can be folded into a query that is sent to the data sources. 

So you can just use Views that are centrally updated, and use powerquery for incremental refresh

Like this

let

  Source = Sql.Database("dwdev02","AdventureWorksDW2017"),

  Data = Source{[Schema="dbo",Item="FactInternetSales"]}[Data],

  #"Filtered Rows" = Table.SelectRows(Data, each [OrderDateKey] >= Int32.From(DateTime.ToText(RangeStart,[Format="yyyyMMdd"]))),

  #"Filtered Rows1" = Table.SelectRows(#"Filtered Rows", each [OrderDateKey] < Int32.From(DateTime.ToText(RangeEnd,[Format="yyyyMMdd"])))

in

  #"Filtered Rows1"