Forum Discussion

SergioHB's avatar
SergioHB
Icon for Helper I rankHelper I
6 years ago

JIRA & PowerBI

Hi all,

 

I've managed to connect using the Jira Content Pack to the Jira Service Desk but I cannot get all the information related to cases. When I copy-paste the json results in a browser, all the information is coming but I cannot make it visible inside the GetIssues table.

 

For example, let me share a piece of it. Here's the result of the call, customfield_11700 brings id, name, ...

 

but I can't make this being part of the 'GetIssues' table, query as follows:

 

Thanks for helping, still a newby with REST integration.

Sergio

 

General Comment
Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    You should check with power query in the custom column.

    • SergioHB's avatar
      SergioHB
      Icon for Helper I rankHelper I
      6 years ago

      Thanks Sosa, 

       

      This is where I'm struggling to get the detail. It'd be great if you could share a bit more detailed or with an easy example.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi  SergioHB ,

         

        Go to menu bar>transform data>new source >blank query:

         

        Then put the codes inside the query.

         

         

        Best Regards,
        Kelly
        Did I answer your question? Mark my post as a solution!