Power BI Dataflows on Steroids: Handling 100+ million records


Power BI dataflows are used for self-service data preparation within the Power BI ecosystem. When a large volume of data and complex transformations should be handled, Enhanced Compute Engine should be enabled to support DirectQuery queries against Power BI dataflows and accelerate the transformations in upstream dataflows.

We will also present in detail the best practices for Power BI dataflows to manage such a huge volume of data. We will focus also on how to store dataflows in your organization’s ADLS (Azure Data Lake Storage) Gen2 account instead of using the built-in one.

At the end of the session, you will learn about:

  • Power BI Dataflows Best Practices
  • How to leverage ADLS (Azure Data Lake Storage) Gen2 to store dataflows
  • Enhanced Compute Engine