Enabling reuse by moving queries from datasets to dataflows

Power BI dataflows are a great tool to enable the reuse of data - and of the logic used to produce that data. But what if you already have queries that are part of multiple datasets? This video covers exactly this scenario, starting with multiple datasets that contain redundant queries, and ending with a single dataflow that is used by both datasets.

---

Intro/outro music by David Fau

--

Sword logo artwork by Beth Hammer

[karinahulka]

love the name of this channel and it has metal in intro❤

[nickfaleev]

Wow ... It was beautiful! Thank you Matthew for your videos.

[kostaskolotouros]

Very interesting topic and clear explanation . Thank you

[SandeepPawar]

Great, best tutorial so far. thanks for sharing.

[Bharathrs]

Thanks a lot... This is really helpful

[jefflingen]

Besides the advantages of the linage view and consolidating transformations for third party data like the worldbank example, do you recommend this same approach when the "reused" data primarily comes from conformed dimensions in the data warehouse? Do you recommend creating dataflows for the other commonly used queries in your example dataset that come directly from the adventureworks database?

[eleftheriakoniari]

Hi there! Data that are in a dataflow and used in several power bi datasets are being duplicated? For example if I have a table in a dataflow that takes x space of my workspace, everytime I use this table in a dataset this will take x space multiplied by the datasets it is being used in?

[danielweikertsn]

Thanks Matthew. Is there a build in (quick) solution to get the percent difference from a bar chart? I only found %of Total as a build in feature. For other things I need DAX logic like divide with dateadd, ... which in kind of cumbersome.

[DeepakSharma-hjgz]

Thanks for sharing this tutorial. Is this Premium only feature?