Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

powerbi load JIRA worklog via RESTAPI so slow

hi,  guys Basically, probem I met is the same as https://community.powerbi.com/t5/Desktop/Get-data-from-Jira-Rest-API/td-p/516130, but can not solved by its solution OR maybe I do not understand ful...
Need Help
v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

Hi Anonymous ，

 

Go to query editor,at the bottom of column profile, choose"entire dataset",as shown below:

Then remove "    #"Invoked Custom Function1" = Table.AddColumn(#"Add worklog url", "worklog", each Json.Document(Web.Contents([worklog url])))" and go to the column "#"Add worklog url",check the number of rows and distinct rows to see whether they are close to: (using groupby functionality)

 

 
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
 
Anonymous's avatar
Anonymous
Not applicable
6 years ago

v-kelly-msft,

 

#"Invoked Custom Function1" and "#"Add worklog url" have the same number of rows

(distinct  row), about 4000 rows. But to be honestly, I don't know the point to check rows count after we both realize 4000 rows lead 4000 API calls maybe cause  time-cost. what I am  curious is how poor performance gone at https://community.powerbi.com/t5/Desktop/Get-data-from-Jira-Rest-API/td-p/516130, am  I missing  something?

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    6 years ago

    Hi Anonymous ，

     

    Then you'd better use another kind of API which can process multiple queries...

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!