Forum Discussion

bhavsar08's avatar
bhavsar08
Frequent Visitor
4 years ago
Solved

Unable to create relationship.

Dear Experts, i have two tables, one column contains unique id's and from another table one column contains unique + duplicate values and i wanted to create a relationship "one to many" as for one to...
Need Help
  • bhavsar08's avatar
    bhavsar08
    4 years ago

    Hello Experts, 

    the issue is resolved, i had smartsheet connected to PBIX and the issue was i wanted one to many relationship but in my first column there was text mentioned, and that caused the table not to convert to numbers, so i removed those and applied one to many relationships. so even i have duplicates in second column now i am able to create relationship.
    Thanks All!



    Cheers!

bhavsar08's avatar
bhavsar08
Frequent Visitor
4 years ago

Hello Experts, 

the issue is resolved, i had smartsheet connected to PBIX and the issue was i wanted one to many relationship but in my first column there was text mentioned, and that caused the table not to convert to numbers, so i removed those and applied one to many relationships. so even i have duplicates in second column now i am able to create relationship.
Thanks All!



Cheers!

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi bhavsar08 ,

     

    Glad to hear that your problem has been resolved. Please mark your own reply as the solution!

     

    Best Regards,

    Stephen Tao