Forum Discussion

Anton_Sotty_IC's avatar
Anton_Sotty_IC
New Member
1 year ago
Solved

PowerBi - Smartsheet Integration

Hello All,   I am on a PowerBI project that was originally working and is connected to Smartsheet, however, this error is now preventing a lot of columns/data from smartsheet from being brought ove...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anton_Sotty_IC ,

     

    Based on your error description, because of the occurrence of blank values, the creation of a one-to-many relationship fails (because you have no blank values before, the one-to-many relationship can exist normally).

    My suggestion is to check your table Portfolio Summary, remove blanks values, or modify the properties of the relationship.

    Similar post: powerbi - Get "not allowed for columns on the one side of a many-to-one relationship" errors - Stack Overflow

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Anton_Sotty_IC ,

 

Based on your error description, because of the occurrence of blank values, the creation of a one-to-many relationship fails (because you have no blank values before, the one-to-many relationship can exist normally).

My suggestion is to check your table Portfolio Summary, remove blanks values, or modify the properties of the relationship.

Similar post: powerbi - Get "not allowed for columns on the one side of a many-to-one relationship" errors - Stack Overflow

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.