Forum Discussion
Proper workflow for dataflows using merged tables
Hi, I have a SQL Source of which, for this example, I want to load Table A and Table B, but also want to add some columns from Table B to Table A via a Merge. First workflow I tried: 1. Stag...
Fair point and that's usually what I do, so this is an exception. Thus I wanted to do it as far upstream as possible (can't change the views so that's where it ends) rather than a calculated column in DAX.
In my personal opinion a dataflow is only useful to shield the developers (NOT the report users) from a slow data source. If your data source is not slow then eliminate the dataflow and use a dataset with incremental refresh.
I plan on using the dataflow in multiple datasets, that's the reason I choose a dataflow.
