Having issue with Live Connection Data Model

[vinothkumar1990]

Hi,

 I have two live connections i.e. LC1 and LC2 and primary key in both the table is PK. I want to compare both the result.

So what i did, i have called both the live connections in power bi desktop and modeled with LC1-PK and LC2-PK with one to one relationship(Both Direction). 

I have a scenario where PK column value 'XXX' is present in LC1 but not in LC2. 

When i create the table matrix report with the column PK from LC1 with the filter PK = 'XXX', it shows the data. But when i add the column PK from LC2 in the same report then report is not showing any data. What i expect is PK from LC1 should have value and PK from LC2 should be blank.

Thanks,

Vinoth

[Anonymous]

Hi @vinothkumar1990 ,

Sorry that I can't reproduce your problem as I tested... How did you create the visual and set the filter in your report? Could you please provide some sample data(exclude sensitive data) in LC1 and LC2 table? Thank you. 

Best Regards

[amitchandak]

@vinothkumar1990 , while your model is not clear to me year.

Filter should come from the common table - LC-PK column

can you share the data model?