Before you start, your Jira Cloud administrator should grant you Administer Jira permissions to create, edit, watch, and export connectors.
Users with Administer Jira permissions always have access to Looker Studio Connector for Jira.
How to Export Data from Jira to Looker Studio
1. Create Access Token
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.
If you need detailed information on how create access token, please refer to our step-by-step instruction.
2. Create Data Source
To create data source in Looker Studio Connector, please refer to our step-by-step instruction.
3. Export Data into Looker Studio
Export Data into Looker Studio
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
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.
If you’re using Power BI Connector for Jira, find a few minutes to leave us honest review.
