March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello,
I have a dataset with combined data load (import and direct query). I want to create a m:n relationship between to tables. But it is not possible because Power BI tells me that a dublicated value exists in my "1"-side table. But I don't want to create 1:n relationship. I cannot create this relationship, I tried the drop down way and I tried to create the relationship in the "create relationship" window.
Here is a screenshot:
Did anyone face a similiar issue? Is there a fix?
Solved! Go to Solution.
@synMo , You should be able to create m-m relation. Please delete any existing join between these two tables. Make sure the data type of the columns is the same. and then try again
@synMo , You should be able to create m-m relation. Please delete any existing join between these two tables. Make sure the data type of the columns is the same. and then try again
Okay thank you. I deleted all relationships to the direct query table and now it works. The error message was a bit confusing when I was using a m:n relationship.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
121 | |
97 | |
85 | |
69 | |
61 |
User | Count |
---|---|
138 | |
116 | |
114 | |
99 | |
98 |