Incremental refresh only works for data sources where query folding is taking place. To my understanding Power BI Dataflow is not one of them. As I would like to offload both the actual data source as well as the Premium instance, I would like incremential refresh to work in both the Power BI Dataflow as well as in Power BI Dataset. If not, I need to choose. Rational: To be able to build an efficient ETL/ELT flow I need to be able to utilize incremental refresh both at the staging layer as well as in the data transformation and data model load layer. Workaround: If I instead of using Power BI Dataflow uses a SQL DB as a middle layer data store, I can do incremental refresh to the SQL DB and then also use incremental refresh from the SQL DB to the Power BI dataset.
2021 Release Wave 2