Function: I am asked to build a dashboard that can automatically extract issue data from Jira and update in PowerBi on a scheduled interval.
Question 1) How best can I automate Jira into PowerBi and what are the parameters needed to access (see problem)
Question 2) How should I structure the flow ( what triggers/actions do I need) to automate the JSON pull from Jira into PowerBi? (see problem)
Problem
I am attempting to establish a connection to a Jira API from Power Automate using an HTTP request. I have confirmed that API is open using Postman and have successfully connected to the API and extracted a JSON collection. However, my requirement is to automate the process with PBI/PowerAutomate. For context, this is the URL I used to connect to Jira in postman along with my Bearer Token https://jira.boozallencsn.com/rest/api/2/search?jql=project=DARKLABS&maxResults=1000.
I then an attempted to replicate the success in Postman in powerautomate with no success. I also tried the Jira connector with no success. See images below.
How do i connect to JIRA on premises
Hey @mckod ,
To build on the response of @Srini007 , any URL used in Power Automate must be internet accessible. When I check your URL, it does not respond at all and instead no connection can be made. If it were internet accessible, I would at least expect a 401 response to indicate that I am not authorized. The easiest way to tell if your URL is internet accessible is to hit it from a non-work resource, such as your phone using mobile data or your home computer. From the JIRA connector documentation:
"JIRA Server behind a firewall or with REST API disabled is not supported."
Hi @mckod
Is Jira is a on-prem instance? better you ask of a cloud based then you can configure with the Jira Connector
Check below link for your reference
https://www.youtube.com/watch?v=gOP4jSWsYNk
Hope this may help you
Thanks
WarrenBelz
146,771
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional