Tables.GetRelationships

Tables.GetRelationships is a Power Query M function that retrieves the relationships between a set of tables with a similar structure to a navigation table. The function returns a table with the relationships among the specified tables.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365

Syntax

Tables.GetRelationships(
   tables as table,
   optional dataColumn as nullable text,
) as table

Description

Gets the relationships among a set of tables. The set tables is assumed to have a structure similar to that of a navigation table. The column defined by dataColumn contains the actual data tables.

Related functions

Other functions related to Tables.GetRelationships are:

• Table.HasColumns
• Table.IsDistinct
• Table.IsEmpty
• Table.MatchesAllRows
• Table.MatchesAnyRows
• Table.Profile
• Table.Schema

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/tables-getrelationships