JIRA REST API + POWER BI INTEGRATION

Question

Hello Guys!

Currently studying Power BI + JIRA Server integration;

is it possible to get data using via rest/api combined with a JQL query?
example I only need to import certain data fields filtered with JQL so few data can be loaded to my BI table.

if so, can you share some resources where can I refer to.

:)  Thank you

Jayson

Anna Odrynska - Alpha Serve · Answer

Hi @Jayson Barrrientos

You can also try our Power BI Connector for Jira plugin. It is still supported and available for Jira Server.

As per your request, the app allows you to apply basic or JLQ filters and to select the relevant fields for export, thus you could get only the data you need in Power BI. You can check app documentation on filters here to understand if it fits your need: https://aserve.atlassian.net/wiki/spaces/POWERBI/pages/696713277/User+Guide

BR,

Anna

Ajay _view26_ · Answer

Hi @Jayson Barrrientos

Welcome to the community.

You can use the Search API along with the desired JQL to satisfy your use-case

Refer to the documentation link below - https://docs.atlassian.com/software/jira/docs/api/REST/8.19.0/#search-search

Cheers

Ajay