Forum Discussion

Vitaliy's avatar
Vitaliy
Helper I
7 years ago
Solved

Get data from Jira Rest API

Hi 2 all and sorry for my English! I have a question that has been torturing for 2 days already. I have a table MYTABLE with 2 columns (URL and Index)of the form: URL Index jira.test.com/r...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    7 years ago

    Hi Vitaliy,

     

    I have found a performance issue in your code. Though I don't know if other parts like Jira API could influence the performance. It could run faster. I tested with 100 thousand rows this time. It even finished in seconds. Please give it a try.

    let   
        //other parts are good without cahnges. 
        ... ...
    #"Source"= Table.AddColumn(#"AddIndex", "Custom1", each Json.Document(Web.Contents([Custom]))),
    ... ...
in
    #"Filtered Rows1"

    Why? The old code invoked a table which should be avoided in Power Query. 

     

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
7 years ago

Hi Vitaliy,

 

I tested like your scenario. It took only several minutes for 10 thousand rows. You can check it out in the attachment. Maybe you can try Python or R scripts. If you need more support, please provide the complete Power Query code. 

 

Best Regards,

Dale

 

antonstorozhuk's avatar
antonstorozhuk
Helper V
3 years ago

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=overview 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 [email protected]. 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.