Link to home
Start Free TrialLog in
Avatar of Murray Brown
Murray BrownFlag for United Kingdom of Great Britain and Northern Ireland

asked on

Power BI Problem creating relationship between two queries

In Power BI I am trying to create a relationship between two queries as shown in the image below but am getting the error shown in the image. I am not sure why this is because I have copied the column [Store Brand] into Excel and made sure this comprised of unique values only. I have tried all three options on cardinality and don't understand why the option I chose doesn't work. Could someone please explain this and how cardinality works? Thanks


User generated image

Avatar of Tom Farrar
Tom Farrar
Flag of United States of America image

How did you make sure the StoreBrand column was unique in Excel?
SOLUTION
Avatar of Suhas .
Suhas .
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Murray Brown

ASKER

Hi Tom. I copied the data into Excel then sorted the data by the key column. Finally I added a formula that would be TRUE if the cell above the current cell was equal to it. I copied this formula down

ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial