Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

refresh on multiple queries with same source

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 Agreem...
Need Help
Show and Tell
Tips and Tricks
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    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

BA_Pete's avatar
BA_Pete
Super User
4 years ago

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