- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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?
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
05-21-2024 02:18 AM | |||
04-06-2024 06:02 AM | |||
12-20-2023 09:26 AM | |||
08-14-2024 11:19 AM | |||
03-06-2024 10:27 AM |
User | Count |
---|---|
140 | |
110 | |
81 | |
60 | |
46 |