How to Export Data from Jira to Looker Studio

An access token is a security credential used in web applications to authorize and authenticate a user or application’s access to specific resources or date.

We will use access token as a password for Looker Studio to securely transfer data.

You can create your token by accessing Looker Studio Connector inside your Jira Cloud instance.

2. Create Data Source

Now you need to create a data source for data you want to transfer from your Jira Cloud to your Looker Studio. You can easily do it by accessing the Date Source page inside the Looker Studio Connector for Jira.

You have to name your data source, adjust sharing settings, and filter the sections you’d like to be in your data source.

3. Export Data into Looker Studio

Export Data into Looker Studio

1. In the Power BI Desktop, click Get Data → select OData feed, insert the copied Data Source link and click Ok

2. At the next step

• Select Basic authentication

• Enter your account email as a user name.

• Enter the Access Token into a Password field.

• Click Connect

1. In the workspace area click + New > Dataflow.

2. Select the Define new tables option.

3. Select the OData data source type (you can use the search bar to find it faster).

4. Enter the data source URL into the URL field, select Basic Authentication kind. Input your email used for logging into your Jira Cloud instance into the Username and the Access Token into the Password section.

5. Select the tables to export and click Transform data.

6. Perform the transformations you need and click Save & close.

Image Removed

After creating access token and creating data source, you can easily export your data into Looker Studio. Being on the Data Source tab, select ↗ (the Open in Looker Studio icon), authorize, connect, and start working with your data.

If you need more information on how to export data, please refer to our step-by-step guide.