Later add relationship columns?

[vitexo87]

I am carrying the burden of some tables and found the following option in the query editing screen "later add relationship column," What is the function of this option? what she will do when loading the data?

note: this table in question is a fact that will relate to the dimensions

[v-yuezhe-msft · Accepted solution]

Hi vitexo87,

Do you mean the “Include relationship columns ” option in the following screenshot?

 

If that is the case, this option makes sense in the case that you choose tables from Navigator to import data rather than writing SQL statement to import data. For instance, several tables have relationships to the Person.person table in AdventureWorks2008R2 database, with this “Include relationships columns ” option, when you firstly choose Person.person table and want to select other related tables by clicking “Select Related Tables”, Power BI Desktop will automatically select these related tables for you(as shown in the following screenshot ).

However, if you untick the “Include relationships columns ” option, when you firstly choose Person.person table and want to select other related tables by clicking “Select Related Tables”, Power BI Desktop will raise a message like “We didn’t find any more related tables”.

Thanks,
Lydia Zhang