Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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