How the epic data is categorised and imported into Power BI Desktop using Power BI Connector Pro for Jira app

Owned by Kinnera
Last updated: Jul 07, 2022

This article explains how the Epic related data are categorized after importing it into Power BI Desktop using Power BI Connector Pro for Jira app.

Instructions

  1. Log in to Jira and navigate to the global navigation Menu (on the top) → AIO Power BI → My Connector URLs.  
    Please note that the access to the app is controlled by the Access Permissions option, which is accessible only to a Jira administrator. Users will not see the AIO Power BI menu item, if the group they belong to, is not selected. In this case, the Jira administrator can perform the below steps. 
  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.

    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 (which ever issue has the relevant data, else it will show with no value):




  • To avoid delay in importing the data, adjust the JQL to fetch the results within a single project (project = KEY) or selecting the relevant fields only.