01-12-2018 12:04 AM
I have a query that uses a function to call the JIRA Api. This query (JIRA Issues) is then referenced by other queries:
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:
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?
01-15-2018 01:54 AM
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?
01-18-2018 12:58 AM
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.
01-18-2018 01:12 AM
You may find some value in employing Table.Buffer.
See this link for more info