Power BI Connector for Jira (Cloud)
Breadcrumbs

Capacity Planner - Jira Team & Resource Management | Tempo

🛡️

You can now revoke your integration token at any time! This gives you more control over your connected apps and helps keep your account secure.

Tempo Capacity Planner Overview

To be able to analyse Capacity Planner - Jira Team & Resource Management | Tempo app data is necessary for the company owners to ensure making informed and timely decisions. That’s why it is important to integrate all Tempo apps with business intelligence tools such as Power BI, and Power BI Connector for Jira is the proper solution for such integration.

Learn more about Tempo apps data analytics on Tempo blog.

Tempo Capacity Planner fields can be found in a separate Capacity Planner tab.

capacity_planner_tab.jpg

How to Add Tempo Client ID

Tempo Client ID is required to view and export Tempo Capacity Planner data via Power BI Connector for Jira.

  1. Being signed in to your Jira Cloud instance, select Apps, and then select Power BI Connector for Jira.

pbi_connector_for_jira_tempo_-_structure_1_.gif
  1. On the left-side menu, select API Integrations, find Tempo, and then select Add.

pbi_connector_for_jira_tempo_-_tempo_2.jpg
  1. Copy redirect URL.

pbi_connector_for_jira_tempo_-_tempo_2_1.jpg
  1. On the left-side menu, select Power BI Connector, and then select Timesheets.

For your convenience, open Timesheets in a new tab. To do it, right-click on Timesheets, and then select Open link in new tab.

pbi_connector_for_jira_tempo_-_tempo_4.jpg
  1. Select Settings.

supported_apps_tempo_apps_step_5.gif
  1. Scroll down, select OAuth 2.0 Applications, and then select + New Application.

supported_apps_tempo_apps_step_6.gif
  1. In the Name field, enter any name you’d like.

  1. In the Redirect URLs, field, paste the redirect URL.

The redirect URL for this form was copied in step 3.

  1. In the Client type field, select Public.

  2. In the Authorization grant type, select Authorization code.

  3. Select Create Application.

supported_apps_tempo_apps_step_7.gif
  1. Copy the client ID and client secret, and then close the window.

supported_apps_tempo_apps_step_12.gif
  1. Return to API Integrations, and then select Tempo.

  2. Paste your client ID and client secret to the corresponding fields, and then select Save.

pbi_connector_for_jira_tempo_-_tempo_12-13.jpg
  1. Select Authorize Access.

Authorize Access.jpg

The Success! message will appear.

Select Onwards!

Onwards.jpg

Starting now, all users with granted permission to work with the data sources can select Tempo Timesheets, Tempo Capacity Manager, and Tempo Financial Manager data for export.

capacity_planner_tab_pic2.jpg

Tempo Tables Overview

Table Name

Table Fields References

Tempo Teams


tempo-teams.gif
tempo-teams-export-table.gif


Tempo Team Members

tempo-teams-members (1).gif
tempo-team-members-table.gif



Tempo Team Projects

tempo-team-projects (1).gif


tempo-team-projects.gif


Tempo Accounts

tempo-accounts.gif
tempo-accounts.jpg


Tempo Account Projects

tempo-account-projects.gif
tempo-account-projects-exported.gif


Tempo Work Attributes

tempo-work-attributes.gif
tempo-work-attributes-exported.gif


Tempo Worklogs

Tempo Worklogs are exported together with Jira Issue Worklogs. You can find it under the Jira Work Management tab.

Check also how worklogs dates are exported.

tempo-worklogs.gif
tempo-worklogs-exported.jpg


Tempo Work Log Work Attributes

tempo-worklogs-attributes.gif
tempo-worklogs-attributes-exported.gif


Tempo Plans

tempo-plans-and-tempo-dates.gif
tempo-plans-and-tempo-dates-exported.gif


Tempo Programs

tempo-programs.gif
tempo-programs-exported.gif


Tempo Holiday Schemes

tempo-holidays.gif
tempo-holidays-exported.gif
tempo-holidays-exported_2.gif


Tempo Holidays

tempo-holiday-exported.gif
tempo-holiday.gif


Tempo Workloads

tempo-workload.gif
tempo-workloads-exported.jpg


Tempo Timesheet Reviewers

tempo-timesheet-reviewers.gif
tempo-timesheet-reviewers-exported.gif


Tempo Timesheet Approvals

tempo-timesheet-approvals-.gif
tempo-timesheet-approvals.jpg