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

[TiboVDM]

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?  

[v-rongtiep-msft · Accepted solution]

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]

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