webservice multiple calls after "add as new query"

[hbrinck]

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?

[v-xjiin-msft]

Hi @hbrinck,

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.

Thanks,
Xi Jin.

[hbrinck]

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?