Centralizing ETL with dataflows
Data preparation and transformation at an enterprise level, meaning managed centrally, compared to a self-service approach where you can perform your own data cleaning, is one of the most expensive and difficult tasks to manage within a company. Also called centralized ETL, this task is traditionally associated with enterprise tools, but with Power BI dataflows, you can extract, transform, and load data by connecting to data sources, transforming the data applying business logic, and then modeling the data to produce reports and do further analysis.
In this recipe, you will see how you can create multiple dataflows, and that these can be used by multiple users in their data models to produce reports and visualize all these pieces in the lineage view.
Getting ready
For this recipe, you need to have access to the Power BI portal, for which a Power BI Pro license is needed. You also need to have access to a Power BI workspace.
