March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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!
User | Count |
---|---|
90 | |
89 | |
85 | |
73 | |
49 |
User | Count |
---|---|
169 | |
144 | |
90 | |
70 | |
58 |