Power BI / Query: Relationships error - after merging 2 queries

[weslake77]

Hi all,
Here's what I have done:
- I have merged 2 queries/tables - to create, let's call it, Query A
- then duplicated Query A, selected Category column and then "deleted other columns" so as to create a "Category" lookup query/table.
- I then deleted duplicates in this Category table.
- I then went to the Relationships Section
- I tried to link the Category column in the lookup table to the Category in the merged query/table Query A but it returned a "Many to Many relationship" error.

How do I fix this? Help would be greatly appreciated

 

[sandy666]

Many-to-many relationships in Power BI Desktop - Power BI

Learn how to use relationships with a many-to-many cardinality to more easily create data models that contain two or more data sources in Power BI Desktop.

docs.microsoft.com