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.
Cet exercice fait partie du cours
Data Ingestion and Semantic Models with Microsoft Fabric
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.)
Exercice interactif pratique
Passez de la théorie à la pratique avec l’un de nos exercices interactifs
Commencer l’exercice