Forum Discussion

DebbieE's avatar
DebbieE
Community Champion
7 years ago
Solved

Relationships not working

I have Table A with 1 record

 

RowKey

109899918181

 

Then Table B contains 2 records

 

ID

109899918181, Description A

109899918181, Description B

 

In relationships i Power BI Desktop I connect up these two tables One To Many RowKey to ID

 

Then I create a table and drag it an item from both tables and they are clearly not connected. 

 

Does anyone else have a problem with this? Am I doing something wrong? Any help would be appreciated

 

Debbie

  • Got it, There is a space at the front of one of the IDs!

1 Reply

  • DebbieE's avatar
    DebbieE
    Community Champion

    Got it, There is a space at the front of one of the IDs!