PowerBi - Smartsheet Integration

[Anton_Sotty_IC]

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!

[Anonymous · Accepted solution]

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...

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.

[lbendlin]

No limitations mentioned on the documentation page. But they have a help link ...

Power Query Smartsheet connector - Power Query | Microsoft Learn