Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 47 | |
| 36 | |
| 27 | |
| 15 | |
| 15 |
| User | Count |
|---|---|
| 58 | |
| 56 | |
| 38 | |
| 21 | |
| 21 |