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.

rohit1991's avatar
rohit1991
Icon for Super User rankSuper User
7 months ago

Hii akatz3 

 

Jira Server/Data Center can be connected to Power BI using Get Data → Web and the Jira REST API. Use Basic auth: username:password (or username:PAT if your Jira version supports Personal Access Tokens), then in Power Query call an endpoint like /rest/api/2/search?jql=... and pass the Authorization header as Basic <base64(username:PAT)>. In Power BI set the Web source credentials to Basic, and if your Jira is internal you may need an On-premises data gateway for scheduled refresh in the Service.

akatz3's avatar
akatz3
Frequent Visitor
7 months ago

Do I do this in the advanced web connector screen? Or the "M" Query itself?