Get startedGet started for free

Data Aggregation

In this exercise, you will create a Dataflow that loads a data file, and use the Power Query interface to see how data could be aggregated to create summary tables.

Table Description
ds-orders.csv Contains sales data per customer, employee and date

Note: If you get an error about an API rate limit, this usually happens because a previous Fabric task has not completed. You can view active Fabric tasks from the Monitor page (located on the left horizontal menu). Canceling old Fabric tasks in the Monitor page will usually resolve the rate limit error.

This exercise is part of the course

Transform and Analyze Data with Microsoft Fabric

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise