Forum Discussion

domc23's avatar
domc23
Icon for Helper I rankHelper I
8 years ago
Solved

Connect columns from two separate data sources

Hello,   I have two separate data tables that I am trying to connect a column from each one so that I can filter on the data and it will control both tables. On the Claims Audit table, there is a c...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi domc23,

    But I still cannot make any releationships between the newly created table and the original data source tables. I am getting the "You can't create a releationship between these two columns because one of the columns must have a unique values"!

     

    How can I get around this error. If I can get past this, I think I am home free.

    Based on my test, you should be able to use the [Group Name] (instead of [Group Number])column to make relationships between the newly created table and the original data source tables in your scenario. :smileyhappy:

     

     

    Regards

domc23's avatar
domc23
Icon for Helper I rankHelper I
8 years ago

I have resolved the issue of Power BI crashing when I attempt to create a releationship between the new table that was created and the existing tables by updating to the January 2018 of Power BI Desktop.

 

But I still cannot make any releationships between the newly created table and the original data source tables. I am getting the "You can't create a releationship between these two columns because one of the columns must have a unique values"!

 

How can I get around this error. If I can get past this, I think I am home free.

 

Any help / suggestions is appreciated.

 

Thank you

v-ljerr-msft's avatar
v-ljerr-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi domc23,

But I still cannot make any releationships between the newly created table and the original data source tables. I am getting the "You can't create a releationship between these two columns because one of the columns must have a unique values"!

 

How can I get around this error. If I can get past this, I think I am home free.

Based on my test, you should be able to use the [Group Name] (instead of [Group Number])column to make relationships between the newly created table and the original data source tables in your scenario. :smileyhappy:

 

 

Regards