One fundamental part of Microsoft Fabric is transforming data. Whether filtering, joining, merging or grouping data, there are several options available in Fabric to perform these operations. In this tutorial, we will explain step-by-step how to group data and apply an aggregation function using a dataflow.


A delta table in the lakehouse should be grouped. The grouped data should be saved as another delta table in the lakehouse.


The source data is the delta table student in the lakehouse.


The target is another delta table in the lakehouse.

Step 1: Open Data Factory Experience

We have already signed in into Fabric and opened the Data Factory Experience. We have selected the workspace "dlnerds_workspace".

Here you can see the Data Factory Experience.

Step 2: Create Dataflow

We have already created the dataflow "dlnerds_group_student". Check out the following post if you want to know how to create a dataflow.

How to create a Dataflow in Microsoft Fabric: A Step-by-Step Guide
Introduction Microsoft Fabric is a powerful All-in-One Data Platform (SaaS) in the Azure Cloud that combines various Azure components to cover the fields of Data Integration, Data Engineering, Data Science and Business Intelligence. One key component of the Microsoft Fabric architecture is the Dataflow. In this tutorial, we will explain

Open the dataflow. This takes you to the Dataflow Gen2 interface.

Step 3: Get Data

First, choose a data source. In order to do this, click on "Get data".

A new window opens. Navigate to the "New" tab.

Since the source data is stored in a lakehouse, select the "Microsoft Fabric" tab and choose "Lakehouse".

You can view this post with the tier: Academy Membership

Join academy now to read the post and get access to the full library of premium posts for academy members only.

Join Academy Already have an account? Sign In