Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Relationship between two Text coulmns

I have two tables Error Table & Accounts Table. Both the tables have ID column which is combination of Text and numbers. How can I make relationship among two text columns

Need Help

4 Replies

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    6 years ago

    Not sure about the issue you are seeing.  You should be able to make a relationship between the two text columns if the values match.  Can you describe further?

     

    If this works for you, please mark it as solution.  Kudos are appreciated too.  Please let me know if not.

    Regards,

    Pat

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Power Bi is not detected any relationship or neither allowing relationship.

       

      Error Table has certain error ID's and there are many error IDs linked to account numbers in the account table. 

      • amitchandak's avatar
        amitchandak
        Super User
        6 years ago

        Anonymous , what is the error it gives, when you try to create relation manually?

        Are there few bidirectional relations in the model already