Chapter 9: Performance Tuning with Power BI Dataflows
We already had the chance to see in detail how Power Query works in its Desktop version, where you can perform data preparation and transformations and save all of it in a Power BI Desktop file with the .pbix extension. But what if you would like to reuse Power Query transformations done by others but cannot retrieve the .pbix file? Or what if you want to store them somewhere accessible to multiple users? You can do that, thanks to the Power Query online version that is integrated with the Power BI Dataflows feature, accessible via the Power BI Portal.
In this chapter, we will see how to create, configure, and consume dataflows by exploring the following recipes:
- Using Power BI dataflows
- Centralizing ELT with dataflows
- Building dataflows with Power BI Premium capabilities
- Understanding dataflow best practices
