Updated on

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


   tables as table,
   optional dataColumn as nullable text,
) as table


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.

Other functions related to Tables.GetRelationships are:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: