Power Query: Using SQL to reference within a spreadsheet, to update power query

[mgrady11]

Due to certain circumstances, this is how the data must be accessed.

I am trying to run a power query that, when it refreshes, it will query based on something that is within a specific reference.

I.e.

If I were to query a database that has four sales regions, but I only want to query one region at a time.
So the reference in the spreadsheet, that I would alter, would be either N, S, E or W.
Once one of the regions is selected, the power query would be refreshed and only pull data tied to that region.

Any ideas or resource links would be appreciated.

-Thank you

 

[gazpage]

Would do it like this.

Give the cell with the N, E, S, W a range name.
Create a query that pulls in this range name.
Right click at the top of the colum and choose drill down. Call this query say "Input"

Create a new query that does exactly what you would want it to for one input, say "N". Note the query step where you filter for "N".
Go into the advanced editor, look for the step with the filtering and replace the "N" with Input. Note that you won't need the quotes.