Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. Log in to Jira and navigate to the global navigation menu  AIO Power BI → My Connector URLs.
  2. Click on Add New Connector.
  3. Input the JQL and select the fields that are in the Epic section i.e., Epic Colour, Epic Link, Epic Status, Epic Name, Epic/Theme along with other fields.



  4. Edit the connector name if required and click Save and Close to get the connector URL as shown below:


  5. Copy the connector URL, open the Power BI and navigate to Get data → Other → OData Feed → Connect. 
  6. Paste the connector URL within the Basic and click OK.
  7. Now, select the tables and click Load to import the data within the Power BI. In this case, according to the selected fields within the connector URL, the tables are displayed as below


  8. The reason for the display of EpicTheme and Labels as separate tables is, the fields Labels and Epic/Theme can store multiple values in it. The other fields related to Epic such as Epic Colour, Epic Link, Epic Status, Epic Name stores a single value within them. So they are displayed under the Issues table.

    Note

    The fields are categorized based on the values that are stored. That means, single or multiple values are displayed under the appropriate tables while importing into the Power BI.


  9. If the field Epic/Theme has any values stored in it, the data is displayed under the EpicTheme as shown below:


  10. For the other fields such as Epic Colour, Epic Link, Epic Status, Epic Name the data is displayed under the Issues Table as shown below:

Image Removed




Info

To avoid delay in importing the data, adjust the JQL to fetch the results within a single project (project = KEY).

...