Forum Discussion
Incremental refresh on computed tables in dataflows
I am wondering what is best practice when I have a two layer architecture, comprising Extract the Transform dataflows, and I have incremental refresh on the extract layer. If I want to aggregate, fo...
Look at it from the maintenance perspective. Any additional piece of process will require additional maintenance. They can recommend that and probably have good motives, but it adds to the maintenance.
OK, thanks, but in my experience the oposite is true. As I mentioned above, I have found that I have a lot less issues if I follow their best practice. Most of the issues I have with dataflows are due to bugs in the service, and these reduced significantly when I limited each dataflow to a single datasource, i.e. a single ODBC datasource in the staging layer, and Power BI Dataflows in the transformation layer.