Versions Compared

Key

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

Power BI Jira Connectorapp integrates with Insight (now Assets) in Jira Service Management. This integration further extends the capabilities of Insight asset and configuration management in the Jira cloud and DC/Server to visualize the required data for actionable insights in Microsoft Power BI. With this integration, Insight Attributes and Insight Types fields information can be imported to Microsoft Power BI.

Info
  • Power BI Jira Connector Cloud and DC/Server app (version 4.1.0 and above) offers Insight integration.

  • Power BI Jira Connector requires Microsoft Power BI Desktopsoftware to function.

Note

Pre-requisite to use Insight (Assets):

Steps to integrate Power BI Jira Connector and Insight in Jira Service Management

Info
  • Insight is now called Assets. For more information, refer toInsight is now called Assets.

  • It is required to define a custom field in Jira to import the values of Insight Attributes and Insight Types.

Administrators can define the number of Insight (Asset) Objects to be pulled for the Insight Attributes. For more information, refer to App Settings.

  1. Navigate toJira > Power BI Jira Connector > Connectors > My Connectors.

2. To add a new connector to pull the required Insight fields, click Add New Connector. For more information about creating Connector URLs, refer to My Connectors.

...

The steps below illustrate how to fetch the Insight (Asset) data to import into Microsoft Power BI.

Power BI

...

Connector Cloud

a. To import the Insight data, you must set up the Email and API Token once. Enter the Email and API Token to grant access to Insight dataand select the required Insight fields for the Connector URL. To save the Connector details, click Save and Close.

...

d. To save the connector details, click Save and Close. To know about the checks performed while saving the connector, refer to Form validation.

Power BI

...

Connector Data Center

a. To import the Insight data, select the required Insight fields for the Connector URL. To save the Connector details, click Save and Close.

...

Example

Query provided with invalid syntax

Error message

Limit the search result to a specific object schema name.

Code Block
objectSchema = 

Limit the search result on object schema ids.

Code Block
objectSchemaId in

Limit the search result to a specific object type.

Code Block
objectType = "IT

References