cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
muneern Frequent Visitor
Frequent Visitor

Multiple (duplicate) concurrent API calls

Hi All,

I have a query that uses a function to call the JIRA Api.  This query (JIRA Issues) is then referenced by other queries:

 

Query Hierarchy.png
The problem is that when the data for my report is being refreshed, Power BI is making the same request to the API multiple times:


Fiddler Output.png

 

 

What seems to be happening is that instead of fetching the result once for the parent query and using the result set for the subsequent queries, it is fetching the data multiple times.  This is obviously causing unnecessary strain on the JIRA server. 

Any suggestions on how to fix this?

 

Thanks,

Muneer

 

5 REPLIES 5
v-jianhe-msft Regular Visitor
Regular Visitor

Re: Multiple (duplicate) concurrent API calls

Hi,

 

How is your query like to call the API? Also, you could try wiht storing the data that you've already retrieved either in a "non-refreshable"-query in the query-editor.  You could refer to  How to disable an api call? 

 

Best Regards,

Henry 

 

muneern Frequent Visitor
Frequent Visitor

Re: Multiple (duplicate) concurrent API calls

Thank you for the response -- but the more I think about this, the more I think that this is a bug. 

When Power BI refereshes data queries which have underlying references to other queries, they should wait until the referenced query has processed rather than cause duplicate processing.

ThomasFoster Established Member
Established Member

Re: Multiple (duplicate) concurrent API calls

You may find some value in employing Table.Buffer.

 

See this link for more info

https://community.powerbi.com/t5/Desktop/How-to-Improve-Query-Reference-performance-for-large-tables...

aduval Frequent Visitor
Frequent Visitor

Re: Multiple (duplicate) concurrent API calls

@muneern Did you get a resolution to this issue? I am having the same probem. 

muneern Frequent Visitor
Frequent Visitor

Re: Multiple (duplicate) concurrent API calls

Hi,

 

Unfortunately I did not find a resolution to this issue.  When/If I do, I'll update this thread.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors