Forum Discussion

akatz3's avatar
akatz3
Frequent Visitor
8 months ago
Solved

Connect PowerBI to Jira Server with Rest API

Hi,   Does anyone have an updated method for connecting Jira Server (not cloud) to PowerBI using the web connector and Rest API? As a note, I can create Personal Access Tokens for Jira but not API ...
Tutorial Requests
  • cengizhanarslan's avatar
    cengizhanarslan
    8 months ago

    In Power BI Desktop → Get Data → Web:
    Use the REST endpoint, e.g.

    • Server info:
      https://<your-jira>/rest/api/2/serverInfo

    • Issues search (paged):
      https://<your-jira>/rest/api/2/search?jql=project=ABC&maxResults=50&startAt=0

    When prompted for credentials:

    • Authentication: Basic

    • Username: your Jira username

    • Password: your PAT (not your Jira password)

    If your Jira is configured to accept PATs for Basic auth, this works.

v-saisrao-msft's avatar
v-saisrao-msft
Icon for Community Support rankCommunity Support
7 months ago

Hi akatz3,

Have you had a chance to review the solution we shared by cengizhanarslan? If the issue persists, feel free to reply so we can help further.

 

Thank you.