Pulling data from JIRA via API, using a JIRA Filter

[lewisgrantevans]

Hi all,

Apologies if this has been asked before, i did search but couldn't find an answer to my specific query.

I can pull data into PowerBI from JIRA using the following API link -

https://jira.companyname.com/rest/api/2/search?jql=project=%22DDL%22&maxResults=1000

However, this JIRA project has 22,000 items and I do not want to do 22 seperate data pulls, and at any one time I only need to pull data for the 300 odd active items.

I would like to edit my API link above to include the filter I use to monitor these active items. The Filter URL is -

https://jira.companyname.com/issues/?filter=52881

Is this possible please? I have tried a few logical approaches but no luck so far.

Thank you

[v-xicai]

Hi @lewisgrantevans ,

You may refer to the links:

https://zappysys.com/blog/how-to-import-jira-data-in-powerbi/

https://community.powerbi.com/t5/Desktop/JIRA-amp-PowerBI/td-p/161986

If you still have this issue for Power BI, you'd better create a support ticket in Power BI Support , Scroll down and click "CREATE SUPPORT TICKET", to get further help.

Best Regards,

Amy 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.