How can we access Track and Release data for using into Power BI to create a report?

[Chawla Eekshit]

Im currently figuring out a way to export the list of issues from Track and Release to Power BI, for that Im trying to save it first at Sharepoint via Power Automate. Will anyone be able to guide me what all steps should I follow or is there a simpler or better way to do the above?

[theCode4_company]

Hello @Chawla Eekshit  ,

It's definitely possible and much easier to export the list of issues from Release versions to Power BI using our free plugin Exporter for Jira. However, could you please clarify what you mean by "issues from Track"? This will help us provide more specific guidance.

Best regards,
theCode4 Team

[Chawla Eekshit]

Referring to the image attached here, I want to basically automate the export and access it in Power BI, to visualise the status of issues. Please suggest some free service as this practice is to save time and money of the team members.

Looking forward for a solution ASAP.
Thank you

[theCode4_company]

You are using a Data Center hosting, right?

[Chawla Eekshit]

yes

[theCode4_company]

Unfortunately, in this case, our free app isn't a solution, as we don't have a Data Center version. The other available plugins in the marketplace don't offer free options for Data Center either. Therefore, the best option for you would be to use the REST API. Here are links to topics that might provide a solution:

How to connect Power BI to JIRA using Rest API and without third-party plugins

Atlassian documentation of the Data Center REST API

All the best!