Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Creating relationship without unique values

  Hello All,    I have been try to create a relationship between two columns in power BI but I am getting the message "You cant create a relationship between these two columsn because one of the c...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    8 years ago

    Hi Anonymous

     

    Power BI supports, 1:1, 1:M, M:1 relationships only, not M :M. But there is a work around for this.

     

    Option 1. Create a relationship/ bridge table to handleM:M

    Option 2. Create a Unique column in your current tables ( For example: By concatenating 2 columns to make the values unique).

     

    Thanks

    Raj 

Faye1901's avatar
Faye1901
Helper I
7 years ago

Hi there,

I have a similar problem which I can't seem to resolve with this solution. I also want to create a relationship without unique values. Steps I've taken:
1. Appended query from my two tables - this didn't append properly as both my columns [Project Code] appeared separately but nonetheless I then ...
2. Removed all other columns but the [Project Code 1] and [Project Code 2] that I wanted to append.
Now I get two columns with corresponding null values in each column - see below. If I filter one or other column to remove the nulls the corresponding column reduces in length so I lose my data. Any idea how I can remove the nulls from each column and append as one? Or do I need to understand why the Append Query as new didn't work in the first place?

Thanks
Faye