Power BI -Section headers in the connector URL

Each connector URL has its own section headers which are helpful in determining and categorizing the fields available in Jira in respective sections.

If the connector URL is already created then please go to the below table for the Section header information.

How to create the connector URL?

  • Log in to Jira and navigate to the global navigation Menu (on the top)  AIO Power BI → My Connector URLs. Follow the steps mentioned on this page to create the Application links. Application links setting up step is not applicable for Jira Cloud

  • Please note that access to the app is controlled by the Access Permissions option, which is accessible only by the Jira administrator.

  • If the group (they belong to) is not selected, users will not see the Power Bi Pro menu item. In this case, the Jira administrator can perform the below steps:

    • Click on Add New Connector.

    • Select the appropriate fields available under the section headers to import the respective field's data.

 

For detailed information on the fields, please refer to the table below:

Section headers in connector

Details

Section headers in connector

Details

1

Common

All the basic fields in Jira exists here. Issue key is selected by default in this section.
Any information related to an issue based on the key, status, priority, summary, labels, etc can be found here.

2

Comments

Any information related to comments in an issue can be pulled through the fields from this section.

For example: Comment Author, Comment Id, Comment Created, Comment Updated, etc.

3

Custom

Any custom fields that are created in Jira exists here.
The custom fields can be of Jira defaults or of 3rd party app custom fields.
Note: Though the 3rd party app custom fields appear in the section, the data might not be pulled until there’s an integration between the apps.

4

Dates

All the system/custom date fields that are present in Jira can be found here.

5

Epic

All the epic related fields can be found here.

For example: Epic Link, Epic Name, Epic Status etc.

6

Fix Version

Any information related to Fix version of an issue can be pulled through the fields from this section.

For example: Fix Version Name, Fix Version Id, Fix Version Release Date etc.

7

Groups (Requires Jira administrative access)

Any information related to a user group can be found here.

Note: User should have Jira administrator access to be able to see this section.

8

History

Any information related to the history of an issue can be found here.

For example: Time in Old Value, Time in New Value, New Value Start Date, History Author etc.
Note: These fields provide detailed information of the changes done for an issue.

9

Issue Effort

Any information related to time spent and estimates can be found here.

For example: Original Estimate, Time spent etc.

10

Linked Issues

Any information related to issues linked to each other can be found here

For example: Linked Issues: Key, Linked Issues: Direction.

11

Other

All the other information like Security, Components, Votes , Watchers etc can be found here.

12

Parent Issue

Any information related to the parent issue of the subtask can be found here.

For example: Parent Issue Key, Parent Issue Status etc.

13

Portfolio

If the app Advanced Roadmaps for Jira Software (formerly Portfolio) is installed, then the respective fields can be found here.

For example: Parent Link

14

Project

Any information related to the project can be found here.

For example: Project Key, Project Lead, Project Type etc.

15

Project Members

Any information related to the users and roles i.e., members of the project can be found here.

For example: Project Role, Project Member etc.

16

Remote Links (Add only if needed; this will slow down the extract refresh)

Any information related to Application links can be found here.

For example: Any incoming and outgoing links configured.

17

Service Desk

Any information related to Jira Service desk can be found here.

For example: Time to resolution, Resolution etc.

18

Service Desk: Request Types

Any information specific to Jira Service desk request types can be found here.
For example: Request Type: Name, Request Type: Id etc.

19

Service Desk: SLA Cycles

Any information specific to Jira Service desk SLA cycles can be found here.

For example: SLA Cycle Status, SLA Name etc.

20

Sprint

Any information related to basic sprint details can be found here.

For example: Sprint Name, Sprint Goal etc.

21

Sprint Metrics (Add only if needed; this will slow down the extract refresh)

Any detailed information on sprint data can be found here.

For example: Sprint Committed Issue Count, Sprint Committed SP etc.

22

Story Points

Any information on story points can be found here.

For example: Story Points, Story Points Completed, Story Points Remaining.

23

Time Tracking (Worklogs)

Any information related to time logged on an issue can be found here.

For example: Time Entry User, Worklog ID etc.

24

Time in Status

Any information related to an issue being in a particular status for certain time can be found here.

For example: History Status, Status sequence, Time in status etc.

25

Time with Assignee

Any information related to an issue being assigned to a paricular user for certain time can be found here.

For example: History Assignee, Assignee sequence, Time with assignee etc.

26

Users

Any information of a user within the Jira instance can be found here.

For example: Creator: Name, Reporter: Name, Current Assignee: Name etc.