Forum Discussion

akatz3's avatar
akatz3
Frequent Visitor
7 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
    7 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.

cengizhanarslan's avatar
cengizhanarslan
Super User
7 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.

akatz3's avatar
akatz3
Frequent Visitor
7 months ago

I ended up having to use an M script and Bearer token but I made the connection.