Forum Discussion

Pratima's avatar
Pratima
Icon for Advocate II rankAdvocate 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 columns....

 

 

Thanks,

Pratima

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

     

2 Replies

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper 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