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