Relationships exist within a Data Model—one that you explicitly create, or one that Excel automatically creates on your behalf when you simultaneously import multiple tables. You can also use the Power Pivot add-in to create or manage the model. See Create a Data Model in Excel for details. If you use the Power Pivot add-in to import tables from the same database, Power Pivot can detect the ...
Have you ever used VLOOKUP to bring a column from one table into another table? Excel also includes a built-in Data Model that lets you create relationships between tables, which can be an alternative to using lookup functions such as VLOOKUP. You can create a relationship between two tables of data, based on matching data in each table. Then you can create PivotTables and other reports with ...
Power Pivot is a data modeling technology that lets you create data models, establish relationships, and create calculations. With Power Pivot you can work with large data sets, build extensive relationships, and create complex (or simple) calculations, all in a high-performance environment, and all within the familiar experience of Excel.
The MSR algorithm searches for the “best possible” set of relationships to connect the tables in your model. The algorithm detects all possible relationships for the new data, taking into consideration column names, the data types of columns, the values within columns, and the columns that are in PivotTables.
See: Relationships between tables in a Data Model to learn more. The connectors only indicate that there is a relationship between tables. They won't actually show you which fields are linked to each other. To see the links, go to Power Pivot > Manage > Design > Relationships > Manage Relationships. In Excel, you can go to Data > Relationships.