Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register 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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
86 | |
84 | |
83 | |
67 | |
49 |
User | Count |
---|---|
131 | |
111 | |
96 | |
71 | |
67 |