Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I create table with Unique Value in Power Query Editor (made Table.Distinct)
Then i tryed to create relationship with source table but power bi tells me that there is error with many-to-many connection.
But i am sure that table only with unique fields. Can you help me what is problem?
Thanks
Hi @sevastr ,
Please share us your .pbix file, removing real data and sensitive information.
It is suggested to upload your file to OneDrive for Business and then paste the link here.
Best Regards,
Icey
Hi sevast
If you read the message very careful I think it is says only use many-to-many is the table key is not unique
In the relationship dialogue box try change the default cardality from many-to-many to one-to-many.
Please leave kudos if this soution works, thank you.
Good luck!
Try the bridge table. Let's say you have two tables i.e. Table A and Table B.
Create a new table via desktop:
key Table= Distinct(Table[Your Key Column])
Then join the Table A with Key Table and then Table B with Key Table.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |