Forum Discussion
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 tokens, though I believe a PAT should function similarly for Jira Server.
In Power BI Desktop → Get Data → Web:
Use the REST endpoint, e.g.Server info:
https://<your-jira>/rest/api/2/serverInfoIssues 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.
6 Replies
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.
Do I do this in the advanced web connector screen? Or the "M" Query itself?
In Power BI Desktop → Get Data → Web:
Use the REST endpoint, e.g.Server info:
https://<your-jira>/rest/api/2/serverInfoIssues 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.
I ended up having to use an M script and Bearer token but I made the connection.
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.
is it possible to retrieve entire jira data using the above method without the "search" clause? Thank you
