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 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

Vitaliy's avatar
Vitaliy
Helper I
7 years ago

Hi v-jiascu-msft

Thanks for your help, it's really great (and simple) solution.

Why I did not guess on my own.. :)