Create a relationship with autodetect
By using auto-detect feature while creating a relationship, users can establish relationships between tables based on field name and interconnected to data model for report and analyze. Steps-by-Steps guidelines are:
Step 1: Load your Data using the “Home” tab and select “Get Data”.
Step 2: On the modeling view, Go to the “Manage Relationship”.
Step 3: Select “Autodetect” option.
Step 4: Then select the “OK” option.
Creating Table Relationships & Data Models in Power BI
Power BI is the most valuable tool for business/data analytics and has the power to visualize and analyze the data easily and also make informed decisions. In this article, we will cover what is data model in Power BI, relationships in Power BI, how to create relationships in Power BI using the autodetect method and manual method, and editing relationships between tables: cardinality and cross-filter direction.