Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!
Hi to all
I faced several times this issue :
1) create a table distinct()
2) create a relationship with another table
>> and power bi does not allow the one to X relationship
Thanks for you answsers 😉
Solved! Go to Solution.
Hi,
Would I ask you to share sample data here?
It could be happen when you have null value for the value that is distinct and use as a relationship between main table and distinct table
Appreciate your kudos and please mark it as a solution if it helps you.
Hi,
Would I ask you to share sample data here?
It could be happen when you have null value for the value that is distinct and use as a relationship between main table and distinct table
Appreciate your kudos and please mark it as a solution if it helps you.
Vote for your favorite vizzies from the Power BI World Championship submissions!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 58 | |
| 52 | |
| 40 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 111 | |
| 109 | |
| 40 | |
| 33 | |
| 26 |