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 tab 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

The data source URL can be copied using the button:

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

Export data into Microsoft Power BI Service

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.