RelationShip field is always empty

[mvcsharepointde]

I have 2 tables inside Power BI desktop:-

1) GetEmployees. which has those 2 main fiels; EmployeeCode + JobCode

2) GetTimeLedgerEntry. which has this field; EmployeeCode

now i am showing a report to show,filter and sort the GetTimeLedgerEnty. now when i tried to add the JobCode inside the report, i got this error:-

so i click to AutoDetect relation and it link them correctly using the EmployeeCode:-

but the JobCode inside the report will be empty, as follow:-

any advice?

Thanks

[Anonymous]

Hi,HotChilli ,thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.

Hello,@mvcsharepointde .I am glad to help you.

You may need to check in Power BI Desktop that the field that was accidentally shown as null is real data, I suggest you to manually filter in the direction of the relationship, if your data connection mode is not import mode, please check if the data is real data in your data source.
If you can really guarantee that the data really exists, please try to change the direction of one-to-many filtering to unidirectional filtering (from one to *).
Sometimes two-way filtering may lead to unexpected cross-filtering, affecting the completeness and accuracy of the data.
Can you provide a screenshot of a relevant pbix file that does not contain sensitive data, which would help to resolve your issue?

I hope the following checkissue on data is helpful.
URL:
Solved: Relationship query - Microsoft Fabric Community

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mvcsharepointde]

@HotChillino they have values

[HotChilli]

"the JobCode inside the report will be empty" - what fields are in the table visual shown? Are there empty JobCodes in the table GetEmployees?

--

Put a test visual on the page with EmployeeCode and JobCode from only the GetEmployees table (no aggregations). Do you see all the values you expect? If so, add and COUNT(EmployeeCode) from the TimeLedgerEntry table.

Does that work?