Forum Discussion
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...
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
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