It looks like everything you are running into is caused by how Power BI handles DirectQuery and query folding rather than anything specific to Redshift. Import mode is the only mode that supports incremental refresh, so once your dataset switched to DirectQuery to handle the size of your views, incremental refresh became unavailable. Even if the view allowed folding, incremental refresh still would not work because DirectQuery models simply do not support that feature.
Redshift views add another complication because they often cannot fold, especially if they include joins or aggregations, which is why you are seeing the native query option disabled in Power Query. To use incremental refresh with Redshift, the data has to be in Import or Hybrid mode, and the source has to support folding so Power BI can push the date filters back to the source. The typical solution is to replace the view with a table or a materialized view in Redshift so the model can be set back to Import mode. Once the data is coming from a foldable, date-filtered table and the model is using Import or Hybrid mode, incremental refresh will work as expected.
Thank you.
