Reply
TiboVDM
New Member
Partially syndicated - Outbound

The column '' of the table '' ...

Hi community!

 

I currently working on a report that contains the error "The column '' of the table '' contains blank values which are not allowed in a many-to-one relationship". The latter part of the error I understand but the first part ("The column '' of the table ''... ") I don't.

Can someone explain to me what this generally means when Power BI shows something like this?  

1 ACCEPTED SOLUTION
avatar user
Anonymous
Not applicable

Syndicated - Outbound

Hi @TiboVDM ,

From the error message, you table is related to another table, and there is a many-one relationship between current table and another table, right? Please share your DAX formula, and a screenshot display the relationship between two tables. Otherwise, we can't help you without detailed information.

 

Check if one of the tables is getting a new value as blank.

 

I have also found a similar post, please refer to it to see if it helps you.

Solved: Column 'Subcontractor name' in Table 'Truck - XAL'... - Microsoft Power BI Community

  • The property "Is Nullable" is set to "No", make sure that you dont have Null in the column or change the property to "Yes"

If it still does not help, please provide more details.

Best Regards
Community Support Team _ Polly

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

View solution in original post

2 REPLIES 2
avatar user
Anonymous
Not applicable

Syndicated - Outbound

Hi @TiboVDM ,

From the error message, you table is related to another table, and there is a many-one relationship between current table and another table, right? Please share your DAX formula, and a screenshot display the relationship between two tables. Otherwise, we can't help you without detailed information.

 

Check if one of the tables is getting a new value as blank.

 

I have also found a similar post, please refer to it to see if it helps you.

Solved: Column 'Subcontractor name' in Table 'Truck - XAL'... - Microsoft Power BI Community

  • The property "Is Nullable" is set to "No", make sure that you dont have Null in the column or change the property to "Yes"

If it still does not help, please provide more details.

Best Regards
Community Support Team _ Polly

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

Greg_Deckler
Super User
Super User

Syndicated - Outbound

@TiboVDM That there is a bug? I've seen that, but never without the actual name of the column and table. You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)