Skip to main content
cancel
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

Reply
Anonymous
Not applicable

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

Hi,

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.

3 REPLIES 3
aj1973
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

 

Regards
Amine Jerbi

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

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

 

Thanks,

Pragati

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

parry2k
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 https://perytus.com, 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

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