Table Integration and Relationships
In this exercise, you'll explore how to create a semantic model and form a relationship between tables. By linking tables, you'll gain the ability to analyze data together and draw meaningful insights.
We recommend completing this exercise and the upcoming two in a single session, as the same artifacts will be used in the next exercises.
This exercise is part of the course
Data Ingestion and Semantic Models with Microsoft Fabric
Exercise instructions
Create a new Lakehouse, and give it a name of your choice.
,In the Lakehouse, go to the option Get Data > Upload Files and upload the following tables from the Desktop/Datasets folder:
- pizzas_table.csv
- orders_table.csv
- dates_table.csv
- customers_table.csv
Once the tables are uploaded, use the Load to Tables option to load the data from the Files section into the Tables section.
(Note: For the second step, you can only load one file at a time. Wait for each file to fully load into the tables section (this takes about 15-20 seconds), then proceed to upload the next file.)
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise