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.

...

  • To generate a token, click Email and API Token.

    Image RemovedPowerBI_Insight_Token.jpgImage Added
  • Make sure to use the current instance's valid Email and API token. Providing invalid details will result in not fetching the Insight data. To know about the checks performed before importing Insight data, refer to Form validation.

Info
  • You can Change API Token for Connectors if required.

    Image RemovedPowerBI_Insights_ChangeAPI.jpgImage Added

b. Insight Attributes

...

Info
  • AQL for Insight (Asset) Objects is available from version 4.2.0.

  • If the AQL query syntax is not correct, an error message appears. For more information, refer to AQL syntax validation.

  • Click (info) to know more about Asset Query Language syntax and usage. Refer to How to use Asset Query Language syntax.

    Image RemovedPowerBI_Insights_AQL_learnmore.jpgImage Added
  • Select the required Insight Attributes to import.

...

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.

...

Info
  • AQL for Insight (Asset) Objects is available from version 4.2.0.

  • If the AQL query syntax is not correct, an error message appears. For more information, refer to AQL syntax validation.

  • Click (info) to know more about Asset Query Language syntax and usage. Refer to How to use Asset Query Language syntax.

    Image RemovedPowerBI_Insights_AQL_learnmore.jpgImage Added
  • Select the required Insight attributes to import.

...

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