Forum Discussion

rkottap's avatar
rkottap
Frequent Visitor
2 years ago

REST API Connection with JIRA

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 ?

General Comment
Need Help

5 Replies

  • sergej_og's avatar
    sergej_og
    Icon for Super User rankSuper User
    2 years ago

    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's avatar
      rkottap
      Frequent Visitor
      2 years ago

      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's avatar
        sergej_og
        Icon for Super User rankSuper User
        2 years ago

        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

  • Aryna's avatar
    Aryna
    Icon for Post Partisan rankPost Partisan
    2 years ago

    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/

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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=overview.

     

    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.