| Table of Contents | ||||
|---|---|---|---|---|
|
📘 As not all users should have the permission permissions to export Jira data, Jira Cloud Administrators can grant the necessary permissions to work with the Power BI SQL Connector for Jira Cloud for certain specific users or groups of users. Instructions The instructions below show demonstrate how to grant the permissions to work with the connector (ability these permissions, allowing users to create, edit, watch, and export connectors).
Administrators have the permissions to work with the connector by default.
| Table of Contents | ||||
|---|---|---|---|---|
|
How to Enable Power BI Connector for Jira and Grant Permission to Jira Users
In Jira primary navigation menu click Apps and find Power BI Connector for Jira in your app list.
Select Administration from the left-side navigation menu.
At the Power BI Connector for Jira Settings page click the Edit icon.
In the Edit permissions window click the Select groups field and select groups from the available groups in the list. You can select as many groups as you need.
To Select users click the Select users field and start to type the username you want to grant permissions to work with the connector. Select user from the list. You can select as many individual users as you need.
To save the permissions click the Save button.
How to Check User Permissions to Work with Power BI Connector for Jira
If you wish to check which Jira users and/or groups have granted permissions to use the application, go to Apps → select Power BI Connector for Jira → click on the Administration tab on the left.
Configure Tokens to Export Add-Ons Data
Power BI Connector for Jira supports exporting data from the leading marketplace add-ons. You can check the complete list of apps on the Supported Add-Ons page.
To be able to include Jira app data in your export to Power BI, Jira users need to configure each add-on separately.
Tempo apps configuration
Projectrak app set-up
Time in Status app configuration
Zephyr Scale token
Xray app set-up
IP Whitelisting
Here are the current instances IP addresses of Power BI Connector for Jira application. Please add these IPs to your IP allowlisting:
| Code Block |
|---|
35.161.7.18
35.85.205.110 |
IP allowlisting gives you an additional level of control, allowing you to specify which IP addresses users must use to access content for Jira Software, Jira Service Management, and Confluence. When you set an allowlist for Jira Software Premium, it applies to customer and agent-facing portals for your Jira Service Management on the same site.
To view your IP allowlists:
Go to admin.atlassian.com. Select your organization if you have more than one.
Select Security > IP allowlisting.
| Info |
|---|
You will be able to access admin.atlassian.com even if the IP is outside the range of the allowlist. |
| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
Regular users can now view and search the history of their own and shared data sources. However, permission remains in the Administration module. |
How to Grant Permission
Being signed in to your Jira Cloud instance, select Apps, and then select SQL Connector for Jira.
On the left-side menu, select Administration, and then select Edit.
In the Users field, enter the username you want to grant permissions to.
| Info |
|---|
You can select as many individual users as you need to. |
In the Groups field, select the groups you want to grant permissions to.
| Info |
|---|
You can select as many groups as you need to. |
Select Save.
| Info |
|---|
Here you can also view who has permission to work with SQL Connector for Jira, edit and revoke permissions. |
IP Whitelisting
Below are the current IP addresses used by the SQL Connector for Jira Cloud application. We recommend whitelisting them only if you are experienced with the process and confident in managing it effectively.
| Code Block |
|---|
44.225.25.214
52.37.67.206 |
| Info |
|---|
Find out what is the best BI tool for Jira reporting in our blog ⬇️ |