topic Re: Relationships in Power BI in Developer

Relationships in Power BI

Analitika — Wed, 24 May 2023 13:55:03 GMT

Hi,

I would like ask why I can't connect tables one-to-one relationship? I am getting message:

Re: Relationships in Power BI

Greg_Deckler — Wed, 24 May 2023 13:59:19 GMT

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

Re: Relationships in Power BI

Analitika — Thu, 25 May 2023 09:07:28 GMT

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.

Re: Relationships in Power BI

Digger — Thu, 01 Jun 2023 06:56:16 GMT

@Analitika remove blanks