From the course: Introduction to Microsoft Fabric by Microsoft Press

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Create a dataflow to load data

Create a dataflow to load data - Microsoft Fabric Tutorial

From the course: Introduction to Microsoft Fabric by Microsoft Press

Start my 1-month free trial Buy for my team

Create a dataflow to load data

“

- We'll start the lesson with the very basics of dataflows in Fabric. Dataflows are based on the technologies and concepts of Power Query. This means that all data load and transformation logic is implemented in queries, each of which is basically a script in the M Language, containing the definition of the query steps. When defining a query, it's possible to reference another query, and in doing so, you can construct tables to be loaded from smaller building blocks. In this video, I'll show you how to create a Dataflow Gen2 item, and how to create queries in it. Query starts with selecting a connector that packages all the complexities of connecting to specific data sources. We will connect to a data source, apply some basic data transformations, and then select a destination for the query in our dataflow. This last thing is new in Fabric, and if you're familiar with Power BI, you will see how things are a bit different here, due to the new capabilities in Fabric. We will again…

Contents