Connect Power BI to multiple data sources to create reports. Define the relationship between your data sources.
Learning objectives
In this module, you will:
Create relationships between your data sources
Create a new field with calculated columns
Optimize data by hiding fields and sorting visualization data
Create a measure to perform calculations on your data
Use a calculated table to create a relationship between two tables
Format time-based data so that you can drill down for more details
This module is part of these learning paths
Create and use analytics reports with Power BI
Introduction to modeling your data
How to manage your data relationships
Create calculated columns
Optimize data models
Create measures
Create calculated tables
Explore time-based data
Check your knowledge
Summary
One of Power BI's strengths is that you don't need to flatten your data into a single table. Instead, you can use multiple tables from multiple sources and define the relationship between them.
How to manage your data relationships
The Model view in Power BI Desktop allows you to visually set the relationship between tables or elements. A relationship is where two or more tables are linked together because they contain related data. This enables users to run queries for related data across multiple tables. Use the Model view to see a diagrammatic view of your data.