Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

You can adjust all Power BI Connector for Jira settings on a single page. The instructions below will guide you in locating app settings page and provide an overview of all available configuration options.

Info

Platform administrators always have the ability to view, modify, delete, and edit the share settings of any existing connectors in an instance.

Info

To learn more on how to create and manage Power BI table relationships, please read our complete article ⬇️

https://www.alphaservesp.com/blog/power-bi-data-modeling-why-to-create-power-bi-data-model
Table of Contents
minLevel1
maxLevel7

How to Get to Settings Page

There are 2 options for how to get to the application settings page. Feel free to use the one that is more convenient for you.

Option 1

  • Being signed in to your Jira instance, select Power BI, and then select Administration.

The Power BI Connector for Jira Settings page will appear.

Image Removed

pbi_administration.gifImage Added

Option 2

  1. Being signed in to your Jira instance, select the Gear icon, and then select Manage apps.

  1. Scroll down, look for POWER BI CONNECTOR FOR JIRA, and then select Plugin settings.

The Power BI Connector for Jira Settings page will appear.

Image Removedpbi_administration.gifImage Added

Settings Page Overview

Power BI Connector for Jira Settings page includes the following settings:

  • Permission Settings

  • General Settings

  • App Logging Settings

  • Export Logging SettingsCustom Fields Map

The page also has the Reset to defaults button.

Image Removed

pbi_settings.gifImage Added

Reset to Defaults

Reset to defaults - This action will restore all app settings, delete all data sources and their settings, and delete all users permissions.

Once you select this button, the Reset to defaults pop-up window will appear.

  • Select Reset, if you do want to reset all settings and delete data sources.

  • Select Cancel, if you no longer want to do it.

Image Removed

pbi_reset_to_defaults.gifImage Added

Permission Settings

Here Jira administrators can grant permissions to users to create, edit, view, and export connectors.

Image Removed

pbi_permission_settings.gifImage Added

  1. In the Users field, enter the username you want to grant permissions to.

Info

Once you start typing, the drop-down list with usernames suggestions will appear. Select the user from the list.

Changes will be saved automatically.

Image Removed

pbi_permission_settings_users.pngImage Added

  1. In the Groups field, enter the group name you want to grant permissions to.

Info

Once you start typing, the drop-down list with available groups will appear. Select group from the list.

Changes will be saved automatically.

Image Removed

pbi_permission_settings_groups.gifImage Added

  1. In the Project Roles field, enter the role(s) you want to grant permissions to.

Info

Once you start typing, the drop-down list with the project roles you have inside your project will appear. Select roles from the list.

Changes will be saved automatically.

Image Removed

pbi_permission_settings_project_roles.gifImage Added

  1. Select the Edit icon, if you want to make changes.

  2. Select the Clear button, if you want to delete permissions.

Note

Selecting the Clear button, you will erase information from all fields: Users, Groups, and Project Roles.

Image Removed

pbi_permission_settings_edit_clear.gifImage Added

General Settings

The General Settings help to:

  • prevent misuse of the app

  • alleviate the significant strain on Jira

  • improve time to export

Image Removed

pbi_general_settings.gifImage Added

  • Issues Limit - This setting allows you to set a maximum number of tickets that can be exported at the instance level.

  • Fields Threshold - This setting allows you to set a maximum number of fields that can be exported without a warning message.

Info

All changes will be saved automatically.

Image Removed

pbi_general_settings_limits.gifImage Added

App Logging Settings

  • App debug mode records all events related to data source, with the exception of data export, but including creating, editing, cloning, changing owner, etc. It is useful for troubleshooting problems or investigation incidents.

It’s recommended to keep the App debug mode turned on.

Here you can also set up maximum size of your log file.

Info

For example, you set a maximum of size 40 MB, once the log file reaches this limit, the older log events will be automatically deleted and the log recreated from scratch.

Image Removed

pbi_app_logging_settings.gifImage Added

  • Actual Log File Size - This field displays the current size of the log file.

  • The Refresh icon - This option allows you to refresh logs.

  • The Clear icon - This option allows you to manually delete logs.

  • Download Zip - This option allows you to download your log file in a compressed zip format.

  • Download Log - This option allows you to download your log file in its original format.

Image Removed

pbi_app_logging_settings_functionality.gifImage Added

Export Logging Settings

Data Export debug mode records events related to data export.

It’s recommended to keep Data Export debug mode turned off as it can impact your instance performance.

Here you can also set up the maximum size of your log file.

Image Removed

pbi_export_logging_settings.gifImage Added

  • Actual Log File Size - This field displays the current size of the log file.

  • The Refresh icon - This option allows you to refresh logs.

  • The Clear icon - This option allows you to manually delete logs.

  • Download Zip - This option allows you to download your log file in a compressed zip format.

  • Download Log - This option allows you to download your log file in its original format.

Image Removed

pbi_export_logging_settings_functionality.gifImage Added

How to Use Data Export Debug Mode

To minimize the impact of the data export debug mode on your instance, please follow the instructions on its usage.

  1. Create a data source with selected table you’re experiencing issue with.

Info

Filter the data by selecting the project you’re experiencing issues with. Select only those tables and fields you need to be troubleshooted.
If you need detailed information on how to do it, please refer to our step-by-step instruction.

  1. Go back to Export Logging Settings, and then clear the previous logs, if there are any.

  2. Set the size limit of the log file, and then enable Data Export debug mode.

  3. Start exporting your data.

Info

If you need instruction on how to export your data source, please refer to our step-by-step instruction.

  1. After data export is completed, open Export Logging Settings, disable Data Export debug mode, and then download the log file.

Image Removed

pbi_how_to_use_export_debug_mode.gifImage Added

At the moment, the output of the following tables is being logged:

Jira Core

Jira Software

Service Management

Tempo

Insight

Xray

Tempo Budgets

  • Issues (Issues, Issue Effort, Parent Issues, Epics)

  • Issue Links

  • Issue Custom Fields (Issues or custom table)

  • History (Histories, Time in Statuses, Time at Assignee)

  • Projects

  • Sprints

  • Sprint Issues

  • Boards

  • Board Charts

  • Sprint Report Charts

  • Burndown Charts

  • Board Issues

  • Approvers

  • Customer Request Type

  • Request Participants

  • Customer Request Type

  • Request Participants

  • Another Service Management Fields (Issues)

  • Tempo (Issues)

  • Teams

  • Object Schema

  • Object

  • Object Type

  • Object Type Attribute

  • Status Type

  • Role

  • Insight Attribute Value

  • Test Runs

  • Folios

  • Expenses

  • Human Resources

  • Rates

  • Allocations

Custom Fields Map

Select Custom Field defined as Story Points in your system.

Image Removed
Info

Read more on how to effectively connect Jira and Power BI Desktop ⬇️

https://www.alphaservesp.com/blog/connect-jira-and-power-bi-desktop-jira-api-vs-add-ons/