Forum Discussion

Pratima's avatar
Pratima
Advocate II
9 years ago
Solved

Creating relationships between two tables.

Good Day All,   I am facing problem while buliding datamodel in two different tables without having common column between these in Power BI.   While doing Dashboard i am getting null values in co...
General Comment
Need Help
Tips and Tricks
  • MFelix's avatar
    MFelix
    9 years ago

    Hi Pratima,

     

    If the table don't have any common colum when you put the values in a visual you will be getting null values since there is no common information that allows you to make a relation between the information.

     

    I don't know how you have your model set up but in some cases that i have I create an ID column in one table that matches information in the other table allowing me to have the link between both, however you have to make sure that in one of those table the information is unique.

     

     

    Regards,

     

    MFelix

     

MFelix's avatar
MFelix
Super User
9 years ago

Hi Pratima,

 

If the table don't have any common colum when you put the values in a visual you will be getting null values since there is no common information that allows you to make a relation between the information.

 

I don't know how you have your model set up but in some cases that i have I create an ID column in one table that matches information in the other table allowing me to have the link between both, however you have to make sure that in one of those table the information is unique.

 

 

Regards,

 

MFelix

 

  • Pratima's avatar
    Pratima
    Advocate II
    9 years ago

    Thanx MFelix.........................