Fairly new to power queries and finding my feet largely by trial and error.
I have build a master query returning ~ 2000 rows of data covering different regions. I want to create sub reports on different tabs for each region. I can easily do this by copying the original table and applying a filter on region for each new query. As my s/s is already 10mb, I am trying to do this is as efficiently as possible in terms of performance. I understand I can do this also by creating a "reference only" to the master query instead of duplicating and filtering master query (so creating 10 versions of master query with different filters).
I have been trying to do this via Query / Reference menu but not sure if I end up with a "connection only" query as it doesn't say it in the Queries panel on the right.
Anyway, I guess the questions are: 1. What is the difference between queries and "connection only" queries (especially with regard to performance / spreadsheet size)? 2. When is best to use "connection only" query? 3. How to create "connection only" query (ideally via menu not code) and how to check if a query is connection only?