- 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
many to many due to blank
i am getting many to many relationship due to presence of blank values in column, how to resolve this issue?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @powerbiexpert22 ,
According to your description, you want to remove the blank values to make the many-to-many relationship disappear, right?
Then we can remove our blank values in our power query as shown below:
The following is an example of Angith_Nair's approach to the situation where there is a unique value in one table and a blank value in another table:
We convert the blank value to an alternative value that exists and defaults to a unique key, and then we can avoid many-to-many relationships when combining with tables that have duplicate values.
Lastly, if you have blank values in both tables and you don't want to delete any data, then we can use a bridged table to do this:
There are unique keys in the bridge table to help you better handle your unwanted many-to-many relationships, if you still have questions you can check out my pbix file, I also found a related document for you, I hope to help you!
、
Many-to-many relationships in Power BI Desktop - Power BI | Microsoft Learn
Hope it helps!
Best regards,
Community Support Team_ Tom Shen
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
Try to replace the blank values with a single dummy value and append that dummy value in the one side table. Now the cardinality will be one to many.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @Angith_Nair ,
can you explain with example , I am unable to understand this completely
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @powerbiexpert22 ,
According to your description, you want to remove the blank values to make the many-to-many relationship disappear, right?
Then we can remove our blank values in our power query as shown below:
The following is an example of Angith_Nair's approach to the situation where there is a unique value in one table and a blank value in another table:
We convert the blank value to an alternative value that exists and defaults to a unique key, and then we can avoid many-to-many relationships when combining with tables that have duplicate values.
Lastly, if you have blank values in both tables and you don't want to delete any data, then we can use a bridged table to do this:
There are unique keys in the bridge table to help you better handle your unwanted many-to-many relationships, if you still have questions you can check out my pbix file, I also found a related document for you, I hope to help you!
、
Many-to-many relationships in Power BI Desktop - Power BI | Microsoft Learn
Hope it helps!
Best regards,
Community Support Team_ Tom Shen
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
remove the blanks? either via powerquery or directly at the source
![avatar user](/skins/images/29B87CD2E2F3DD25A791B14146161BCB/responsive_peak/images/icon_anonymous_message.png)
Helpful resources
Subject | Author | Posted | |
---|---|---|---|
12-20-2023 08:36 AM | |||
11-19-2023 04:06 PM | |||
05-21-2022 07:08 AM | |||
09-07-2024 06:13 AM | |||
01-20-2025 02:01 PM |
User | Count |
---|---|
120 | |
69 | |
69 | |
57 | |
50 |
User | Count |
---|---|
167 | |
82 | |
68 | |
65 | |
53 |