How do I pull information about linked issues while also displaying the field data for the dependent

Hi danextian I am using PowerBI for data analysis of JIRA data.

Jira is a work tracking data base. In that Data base you can have multiple called issuetypes. The issuetypes all have fields of attributes like due date, status, assignee, etc. 

the entities can have a relationship with each other by creating a "link"!between them. There can be multiple links and they are all captured in a field called issue links see the attached image.

In the image with the yellow highlight you see issue GR-315 expanded to show it has 7 issue links.

to answer your question the data values in the matrix are not expected to be repeated ; they are repeated because the field issuelinks in this matrix is referencing the "issue" and not the issue named in the issuelink. That is the problem I need help solving in powerbi.

how do I pull the fields for the Issue and the fields for the issues it is issue linked to?

I am pretty sure I need to have two tables:

1. A table of the issues of interest like GR-315

2. A table of issues that are linked to the issues in the first table

Both tables would have the issues from the first table as the keyID then I would be able to create a 3rd table with everything in it.

this seems like a lot of work, I am expecting powerBI to be able to do it dynamically.

That is, when the row is one of the issuelinks how do I direct PowerBI to refernce the issuelink to pull the values and not the original issue?

please advise and thanks!