Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Not applicable

blank values and this is not allowed for columns on the one side of a many-to-one relationship


I am getting belo error as one of the column 'X' in table 'A' has multiple null values. But is there a way where PBI can ignore this error although I want to keep the relationship (1-M) between the tables with column 'X' in table A


Error: Column 'X' in Table 'A' 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. Table: A.

Community Champion
Community Champion

Hi @Anonymous 


it depends on what those Null values represent! in power query you have the option to either Fill in Down the rows if they represent the same value as their precedent or use Replace value.

May be an image of your table can help us better to undestand


Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Super User
Super User

Hi @Anonymous ,


This is the basic requirement for creating relationships between 2 tables not just in Power BI, in any other tool, database or platform.

So, you will have to get rid of BLANK/NULL values. Try replacing them with some values like "No Value" or "No Category"; whatever suits as per your data. Then try creating relationships.




Best Regards,

Pragati Jain

MVP logo

LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Super User
Super User

@Anonymous as the message states, you cannot have null/blank values in one side of the relationship table, maybe replace null/blank value with like "unknown" and make sure it is a distinct value.


I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

Visit us at, your one-stop shop for Power BI related projects/training/consultancy.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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