Authoring Dataflows

Dataflows are reusable, scalable self-service ETL (extract-transform-load) artifacts created exclusively in the Power BI cloud service. Dataflows utilize the same Power Query (M) language for data access and transformation that has existed within Power BI Desktop but can be shared across datasets and, with Power BI premium capacity, can support large, resource-intensive workloads.

This recipe demonstrates how to create a dataflow within the Power BI service, and how that dataflow can then be leveraged within Power BI Desktop.

Getting ready

To prepare for this recipe, follow these steps:

1. Download the CH5_R7_AuthoringDataflows.xlsx file from the following GitHub repository: https://github.com/PacktPublishing/Microsoft-Power-BI-Cookbook-Second-Edition.
2. Save the CH5_R7_AuthoringDataflows.xlsx file to your OneDrive for Business directory.

How to Author Dataflows

To implement this recipe, perform the following steps:

...