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 over into PowerBi. here is the following error:

 

 

Error Description: 

Column ‘<oii>Project Reference ID</oii>’ in Table ‘<oii>Portfolio Summary</oii>’ contains blank values and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table. (Project Reference ID (228)). Table: Portfolio Summary

 

My first question is, is this a error on Smartsheet or Windows side?

 

And what potential solutions are there?

 

Thanks!

 

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.

     

2 Replies