How to import Time entry user email data into Power BI from Jira cloud instance

Owned by Kinnera Siriki
Last updated: Sept 30, 2021 by Amith Mathur
2 min read

This article explains how the time entry user email can be imported into Power BI from the Jira cloud instances.

Instructions

  1. Log in to Jira and navigate to the global navigation Menu (on the top) → AIO Power BI → My Connector URLs.
    Note: 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 AIO Power BI menu item. In this case, the Jira administrator can perform the below steps:
  2. Click on Add New Connector.
  3. Input the JQL and select the field Time Entry User Email under the section named Time Tracking (Worklogs).



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



  5. Now, navigate to your Profile → Account settings → Profile and visibility → Contact → Email address to set the visibility to Anyone.
    Note: Each individual user has to follow the above step to get the data into the time entry user email field.


  6. Navigate back to the My Connector URLs page and copy the connector URL.
  7. Open the Power BI, and navigate to Get data → Other → OData Feed → Connect. 
  8. Paste the connector URL within the Basic and click OK.


  9. Now, select the tables and click Load to import the data within the Power BI. The user email will be visible as shown below:


  • The End users have to set the visibility option from their profile option and Jira admin will not be able to do it for all. This is due to the restrictions from Atlassian. 
  • 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.