Unable to include field values from start schema tables into a single table visual

[msksenthil]

I am getting an error "Can't display the data because Power Bl can't determine the relationship between two or more fields." when trying to include fields from the different tables which are all following 1-Many relationship and in a star schema. Is it normal that we couldn't include fields like this without aggregation or am I missing something?

Could someone help me to understand the concept here please? 

[Ashish_Excel]

Hi,

Share the download link of the PBI file.

[v-pnaroju-msft]

Hi msksenthil,

We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.

If our response was helpful, please mark it as the accepted solution and provide kudos, as this helps the broader community.

Thank you.

[v-pnaroju-msft]

Hi msksenthil,

We wanted to check in regarding your query, as we have not heard back from you. If you have resolved the issue, sharing the solution with the community would be greatly appreciated and could help others encountering similar challenges.

If you found our response useful, kindly mark it as the accepted solution and provide kudos to guide other members.

Thank you.

[v-pnaroju-msft]

Hi @msksenthil,

Thankyou for the update.

We are following up to see if your query has been resolved. Should you have identified a solution, we kindly request you to share it with the community to assist others facing similar issues.

If our response was helpful, please mark it as the accepted solution and provide kudos, as this helps the broader community.

Thank you.

[v-pnaroju-msft · Accepted solution]

Thankyou, @Uzi2019, for your response.

Hi @msksenthil,

We appreciate your inquiry posted on the Microsoft Fabric Community Forum.

Based on my understanding, the error arises because your model contains one-to-many relationships from Table1 to Table2 and Table1 to Table3. When you pull fields from these tables into the same visual without aggregating them, it creates ambiguity in the row context. Since Table3 has multiple status entries per AID, and Table2 has multiple activity dates, Power BI faces difficulty in determining which specific status or date to display for each person.

Please find attached the screenshot and the PBIX file, which might assist you in resolving this issue:

If you find our response helpful, kindly mark it as the accepted solution and provide kudos. This will benefit other community members encountering similar issues.

Thank you.

[msksenthil]

Thank you for testing it. I really appreciate it. I understand that we can't include fields from multiple tables into the table visual without aggregation.

[msksenthil]

Sorry, this doesn't help with my case. Likewise, I can't upload the document from my end. Hence I just posted the snap of the spreadsheet with sample data. Can you please try from it and share your thoughts?

[Uzi2019]

Hi @msksenthil 

Check these videos for better understanding.

https://www.youtube.com/watch?v=OOs-VWf20E8

https://www.youtube.com/watch?v=sW5LoDA1ssM

I hope above video would help you to understand the relationship .

Incase if you still struggling with relationship please share pbix file using open link (one drive).

will help you.