Forum Discussion
JIRA & PowerBI
Anonymous wrote:
Hey everyone,
I badly need to connect JIRA with Power BI. I did go through a document that has been shared all over the internet but it didn't help me much. For starters, this is the URL that I use, when PBI asks me to enter the URL for JIRA.
https://jira.rd.abcpharma.net/secure/RapidBoard.jspa?rapidView=5048&projectKey=SSCL
This is the link to the Kanban board that is in JIRA, and I'd like to bring it to Power BI. Any help would be much appreciated! :)
TIA :)
Anonymous
When connecting to JIRA, the required URL is like "https://xxxxxx.atlassian.net", while clicking next, it acutally calls the API "https://xxxxxx.atlassian.net/rest/api/2/search".
So simplely speaking, at this moment, Power BI now can only get the data that returnbed by API "https://xxxxxx.atlassian.net/rest/api/2/search", As to your link to other JIRA REST APIs, you can do it by calling REST API in Power BI desktop, this would require REST API and programing skill. Check how to call such similar APIs in a demo Get Data from Twitter API with Power Query.
You can also submit your idea at Power BI Ideas and vote it up.
Hi TiagoMachado, Firstly thanks for your query i was able to get all the issues for a specific project with just a little tweaking! But now i realized that the hidden custom fields are not retrieved using REST API, i need to be able to get values for them. Do you know of a workaround to get this data ?
Thanks in Advance,
Aish
Hi Anonymous
I answered this question on this thread as well:
In order to get the custom_field "human" names, you need to perform another REST call at:
https://xxxxxx.atlassian.net/rest/api/2/issue/createmeta?expand=projects.issuetypes.fields
(where xxxx is your cloud domain)
And then rename the columns on your Power BI.
If there aren't many customfields, it is faster to hardcode the values (the above REST call takes some time to return data - specially when the number of projects you have on your cloud instance increases)
Some helpful references:
Please let me know if it was helpful
Regards
Hi TiagoA
Thanks thats helpful, my problem was that i wasn't getting all the fields. The issue was that with JIRA REST API search function the default behaviour is to get only navigable fields and i needed all of them, Anyways tweaking the url like below worked for me.
https://xxxxxx.atlassian.net/rest/api/2/search?jql=project=XYZ&fields=*all
Aishwarya