Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Can i connect particular project in jira to power bi?(i dont wont to extract all the data ,need only the particular data)
i tried below 2 URL but not able to connect(I tried both power bi desktop and online service)
1. https://xxxx.atlassian.net/projects/DVD
2.https://xxxx.atlassian.net/projects/DVD/issues
Solved! Go to Solution.
Hi ,
I found the solution for the above problem,
If u use below URL u can connect to particular project in JIRA
https://xxxx.atlassian.net/rest/api/2/search?jql=project="project name"&startAt=0&maxResults=1000
Hello,
I’d like to propose and alternative solution for you, you might want to try out our app - Power BI Connector for Jira: https://marketplace.atlassian.com/apps/1221150/power-bi-connector-for-jira?hosting=cloud&tab=overvie... it's available for Jira Cloud / Server / Data Center.
We have a handy User/Admin Guide https://aserve.atlassian.net/wiki/spaces/PBCFJC/overview and fast/responsive support team at support@alpha-serve.com. Please let us know if you need any assistance.
Cheers!
Anton
===
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
No, I am sorry. Nothing yet. We are working with manual exports from Jira 😞
https://XXXXXXX.jira.com/rest/api/2/search?jql=project="XXXXX Apps"&startAt=0&maxResults=1000
I get an error "Unable to connect" Details: "web.contents failed to get contents"
(400)
Now if I take the same URL and paste it into a Browser I get a file with the data...
I am using a "Web" datasource...
Am I doing somethign wrong?
@Anonymous
Power BI connect JIRA via REST API, it actually open calls to "https://xxx.atlassian.net/rest/api/2/search?maxResults=500&startAt=0". So you can only retrieve all data then add filters to get expected result in POWER QUERY. You may atlassian for more details about its REST API.
Regards,
Hi ,
I found the solution for the above problem,
If u use below URL u can connect to particular project in JIRA
https://xxxx.atlassian.net/rest/api/2/search?jql=project="project name"&startAt=0&maxResults=1000
Hi, where do I define which project I connect to?
Hi vmestha,
I am not having success with this method, I am receiving a 503 service temporarily unavailable message.
User | Count |
---|---|
102 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |