refresh on multiple queries with same source

[Anonymous]

I do have an API setup as a source for collecting data, the data set consists of several tables. I so need to split these tables in individual queries since they contain different data. In the Agreement of the API there is a limitation on how many times per day you can call upon the API. My question now is, will Power BI fetch the data for each of the new created queries or will it only fetch once per refresh. Could I also setup a single source query and reference the tables in new queries? Will it than refresh only on the source?

Or will it always connect via the API fetching for every Query again and again? That will be a problem for me because then I will exceed the limited number of times I can use the API per day and get locket out.

Is there someone that has experience with this kind of issue? Please let me know and whether there is a work-a-round for this.

Best,

Collin

[BA_Pete · Accepted solution]

Hi @Anonymous ,

Broadly speaking, Power Query will go to the source for each individual query, regardless of whether it's unique, duplicated, or referenced.

There are some edge-cases where Power Query can do some caching (look for some of Ehren's posts on MS TechNet - now MS Q&A - if you want the extreme technicals on this) but, in general, assume a source-call per query.

You could do a bulk-pull into dataflows then split the dataflow up in Power Query, but this obviously isn't going to be ideal if you need live or near-live info.

Pete