---
title: "Projectrak Integration"
canonical: "https://support.appfire.com/space/APBCFJ/621772920/Projectrak%20Integration"
format: markdown
---
> Macro (aura-html)

*Power BI Connector *app integrates with [Projectrak](https://marketplace.atlassian.com/apps/1210816/projectrak-project-tracking-for-jira?hosting=cloud&tab=overview). 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](https://confluence.deiser.com/projectrak/8.1.9/advanced-search-with-pql-project-query-language-110956185.html)(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.

> ℹ️ - *Power BI Connector* Cloud and DC/Server app (version 4.1.0 and above) offers Projectrack integration.
> ℹ️ - *Power BI Connector* requires Microsoft Power BI Desktop** **software to function.

**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](https://appfire.atlassian.net/wiki/spaces/APBCFJ/pages/578912311).

![PowerBI_Cloud_AddNewConnector.jpg](media://0e1a0890-1a6c-42a7-84b5-364eae54966c)

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.

![PowerBI_Projectrakfields_DC.jpg](media://00a3e0c5-693a-4e8e-8ab0-4dd15c30a431)

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](https://confluence.deiser.com/projectrakcloud/developers-110955371.html). You can *Change API* *key* for Connectors if required.

![Projectrak fields_enter API ID and Key](media://b3a0049e-7105-4974-9fb3-df606df5ac7a)

> ℹ️ Click *API key ID and API key and n*avigate the page with steps to generate the API key.

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**.

![Select the required Projectrak fields ](media://793e69e4-8a1e-4489-b9c1-7dda573f4028)

**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**.

![DC_Select Projectrak fields](media://a0ca647e-8f58-434f-9e2e-69028f002c50)

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](https://appfire.atlassian.net/wiki/x/UQDlAw).

![DC My connectors](media://7d4688e9-dec0-4f20-b9c0-f640a3fd5510)

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

![ProjcectrakPowerBI_Tableimported.png](media://6a209ec9-c3cb-457c-87aa-b3084b302c22)

# References

- [Power BI Connector](https://appfire.atlassian.net/wiki/x/BwDlAw)
- [Install Power BI Connector](https://appfire.atlassian.net/wiki/x/GIB6Ig)
- [My Connectors](https://appfire.atlassian.net/wiki/spaces/APBCFJ/pages/578912311)
- [Import into Power BI](https://appfire.atlassian.net/wiki/x/KoF6Ig)