9

Data Cleansing in the Cloud with Dataflows

Power BI dataflows are a new, robust, self-service extract, transform, load (ETL) option in the Power BI service. Dataflows allow you to use the Power Query Editor online and leverage your transformational work in a reusable format, both individually and with other people. Currently, you can save dataflows in your Power BI workspaces and your organization’s Azure Data Lake Storage account. When created in Power BI, dataflows are always categorized as analytical dataflows, in contrast to the dataflows created in “Power Apps”, which may be analytical or standard. These are saved in Microsoft’s Dataverse. In this chapter, we cover analytical dataflows created in the Power BI service.

Dataflows help organizations ...

Get Microsoft Power BI Quick Start Guide - Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.