Forum Discussion
AndrewZ
Helper I
Helper IUsing a dataflow as a source for another dataflow
Hi All We on PowerBI premium and have set up a nice central dataflow for finance that is used by multiple datasets as the one true source of data and its been working well. We have row level secu...
In your new dataflow, 1) build a first query that references the source dataflow but doesn't load it, 2) reference that query in a second one which you do materialize (i.e. Enable load). This way you're not using Linked Entities and can add filters or any other transformations (in the first or second query, it doesn't really matter).
lbendlin
Super User
Super UserThat's not what dataflows are for. They are glorified CSV/Parquet files. Filtering a dataflow comes with a big performance penalty. You should do your filtering in the datasets, or consider using datamarts (either on premise or provided by Power BI)