Forum Discussion

Shanebenedict's avatar
Shanebenedict
Icon for Advocate I rankAdvocate I
9 years ago

Relationships Not Working

I have a sales report and a stock report which i want to link with the product code which is the unique code in both sheets, however i am not able to create a relationship between the 2 files.

 

Show and Tell

7 Replies

  • dedelman_clng's avatar
    dedelman_clng
    Icon for Community Champion rankCommunity Champion
    9 years ago

    PowerBI is usually pretty accurate when it comes to detecting non-unique values.  Check your source data.  Query Editor also has a "Remove Duplicate Rows" feature.

     

    Hope this helps,

    David

    • Shanebenedict's avatar
      Shanebenedict
      Icon for Advocate I rankAdvocate I
      9 years ago
      Dear David,

      Thank you for your message however there are no duplicates nor blank spaces inbetween and hence I am trying to break my head with that.
  • wmh's avatar
    wmh
    New Member
    8 years ago

    Did you get a resolution to the relationship issue?  I am having the exact same problem.

    Thanks, Bill