Forum Discussion
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: The problem is that when the data for my report is being ...
I was facing same issue of Power query making multiple connection to the sourcce instead of fetching data from the parent table\query1 and came accros this post. The solution provided by microsoft was to use DATA FLOW in power bi service, once data flow is created for query1 that becomes your source in power bi desktop, any sub/reference/duplicate queries will go to the data flow and fetch the data instead of going to the source.
https://docs.microsoft.com/en-us/power-bi/guidance/power-query-referenced-queries