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
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.
  • dedelman_clng's avatar
    dedelman_clng
    Icon for Community Champion rankCommunity Champion
    9 years ago

    Can you share anonymized data or the pbix file?

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

      How do i share the pbix file 

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

        Usually people put it on Dropbox, Google Drive, OneDrive or the like and put the link in a response.