Power BI Connector app integrates with Projectrak. Projectrak is a project tracking solution for Jira. It provides you with preconfigured project fields and the ability to create new project properties. Perform dynamic project search using PQL(Project query language), define the layouts and views based on your preference to visualize and track the Jira project portfolios.

This integration further extends the capabilities of Projectrak to export and visualize the required project properties for actionable insights in Microsoft Power BI.

Steps to integrate Power BI Connector and Projectrak - Project Tracking for Jira

1. Navigate to Jira > Power BI > My Connectors.

2. To add a new connector to pull the required Projectrak fields, click Add New Connector. For more information about creating Connector URLs, refer to My Connectors.

Open

3. A form is presented with Jira and Projectrak fields to create the Connector URL. The Projectrak values list the Projectrak fields. To provide the details, select the Projectrak values field.

Open

4. Import Projectrak data.

Power BI Connector Cloud:

a. To import the Projectrak data, enter the API key ID and API key. To generate API key ID and API key, follow these steps. You can Change API key for Connectors if required.

b. Enter the API key ID and API key to grant access to Projectrak data and select the required Projectrak fields for the Connector URL. To save the Connector details, click Save and Close.

Power BI Connector DC/Server:

a. To import the Projectrak data, select the required Projectrak fields for the Connector URL. To save the Connector details, click Save and Close.

5. Add the Connector URL generated to Power BI Desktop as a Data Source to import the Projectrak data into Power BI. For more information, refer to Import into Power BI.

6. The Projectrak data gets imported and appears in a table format in Power BI.

References

• Power BI Connector

• Install Power BI Connector

• My Connectors

• Import into Power BI