Power BI Dataflows Essential Training

Boost efficiency and eliminate duplicate work by learning how to use Power BI dataflows. Discover how to scale the ETL process across many users of Power BI data and dashboards.

Introduction

• Optimizing your data with Power BI dataflows
• What you should know

1. Working with Data in Power BI

• Navigating the Power BI ecosystem
• Comparing Power BI versions
• Utilizing a dataflow
• Utilizing Azure Data Lake

2. Extracting Data

• Setting up gateways
• Organizing data sources
• Connecting to databases
• Setting up web connections
• Querying API data
• Connecting to Excel

3. Transforming Data Connections

• Updating dataflows
• Utilizing Power Query Online applied steps
• Translating from Power BI Desktop
• Setting up a Common Data Model

4. Loading and Connecting to Dataflows

• Connecting to dataflows
• Comparing dataflows to data sets
• Sharing dataflows
• Scheduling data refreshing
• Representing dataflow structures with JSON files

Conclusion

• Next steps with Power BI dataflows