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
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