Reply
Topic Options
- 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
Relationships in Power BI
05-24-2023
06:55 AM
Hi,
I would like ask why I can't connect tables one-to-one relationship? I am getting message:
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-24-2023
06:59 AM
@Analitika Somewhere you have a duplicate value in those columns or you have unmatched rows. The first issue might be caused because of the case insensitivity of DAX, something like AQ701 is the same as aQ701 is the same as aq701 is the same as Aq701, at least as far as Power BI is concerned. But, it really looks like the latter where you have a bunch of rows in your 2nd table that don't match anything in your first table.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-25-2023
02:07 AM
I tried to make table to be distinct but still seems it has duplicates. Seems it is a reason that I can't make one-to-one relationship.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Helpful resources
Top Solution Authors (Last Month)
User | Count |
---|---|
5 | |
5 | |
3 | |
2 | |
2 |
Top Kudoed Authors (Last Month)
User | Count |
---|---|
9 | |
7 | |
5 | |
4 | |
4 |