REST API Connection with JIRA

[rkottap]

Hi Team,

I have established a connection with JIRA site, using Rest API. I have more than 140K records in my JIRA project.

While loading data it's taking lot of time and it's failing finaly with the below error message:

Error: OLE DB or ODBC Error [ Data Source Error] The request was aborted: The request was cancelled.

Could you please advice how to get all the 140K records from JIRA site ? any other approches to get the data quickly ?

[Anonymous]

Hello @rkottap,

I’d like to propose and alternative solution for you, you may connect your Jira on-premise to Power BI with the help of our app - Power BI Connector for Jira: https://marketplace.atlassian.com/apps/1221150/power-bi-connector-for-jira?hosting=cloud&tab=overvie...

With our Power BI Connector you will be able to:

- build reports based on filtering of Jira custom fields and Marketplace apps custom fields
- combine reporting on multiple Jira projects
- use different data sources in single analytics (Jira, CRM, ERP, ITSM, Financial management software, etc)
- create Jira reports in Power BI with built-in Power BI dashboard templates

- scheduled refreshes for actual Jira reporting.

Daria

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

[Aryna]

Hi @rkottap , there are few options available. You can try Alpha Serve (the most commen one) on Atlassian website. It is free for small team, but subscription cost can reach $30000 for larger ones. 

Alternatively, you can try one time service that sets up a script for Jira and Power Bi connection: https://vidi-corp.com/how-to-connect-jira-to-power-bi/

[sergej_og]

Hey @rkottap ,
do you have nested custom function calls (your own functions) during the data refresh? I assume you mean Desktop.
Any query attributes you send with your URL?
I guess you have gone through pagination stuff to get all 140k rows?
Usually maxResult in Jira = 1.000 per page.

Show pls your PQ Code with the endpoint you call. Pls no confidential data.

Regards

[rkottap]

Yes, i'm trying to get the JIRA records using Power BI Desktop and i'm able to pull all the records usng power query with REST API connection, but while loading the DATA from power query to  Power Pivot it's taking time.

Is there any other option to get the JIRA data ?

[sergej_og]

Hey @rkottap 
140k rows is not that much. What do you mean by "it`s taking a while"?
Should work fast.
Can you pls provide your PQ-Code calling the API.

Maybe I can identify smthg...

Regards