How to Fetch Linked Issue's Status if Linked Issue from a Different Project (Using Simple JQL)

[Avik M]

I have a (hopefully) simple question.

I use Power BI Jira Connector to pull and display JIRA from my Project ("ABC"). Now various tickets in my Project are linked to Issue Keys from other projects. So when I am pulling data by using :  

project = "ABC" ORDER BY created DESC

then unfortunately, I dont get to See the Status of those linked issues which are not of my project. Say for Example, ABC-111 is having a "Has to be done After" "XYZ-123" link. In such case I dont see the status of XYZ-123 in my Power BI.

So basically what I needed is:

project = "ABC" OR issueFunction in linkedIssuesOf("project = 'ABC'") ORDER BY Key DESC

But unfortunately, the above Syntax works with ScriptRunner but not with Power BI Jira Connector's JQL, which I guess is offering simple / default Jira Search operations. 

Any Idea - how to overcome this?