We're calling a status-api (webservice) that containes som main data and 4 different "sub-lists"
To access each of the lists we right-clicked on the "List"-link in the Query Editor and selected "Add as New Query", this allowed us to create new "PBI-tables" for each sub-list in the web-response.
This means that we get all data using only one call to the service.
But, when we do "Refresh" (manual) PBI is actually calling our service 5 times, instead of only calling it once.
Any ideas on what's going on?
Per my understanding about your description, there're 4 sub-lists and you have created 4 new queries for all of these sub-lists. Right?
If I misunderstand your requirement, please feel free to correct me.
And if all these 4 new queries are returning different results. Then Power BI will call the service 5 times, as there are 5 queries. Main query and 4 new queries.
The status-api is returning the same result (since all calls are within 0.1 seconds)
I expected the sublist to be dependant on the main "source" since they are parts on the same query.
If PBI cant detect this on it's own, how can i create my datasets to only call 1 and re-use the response into several datasets?
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!