'Using value from Excel cell as filter in MS Power Query
I got an excel file which should use a query from an ms access file (which is a front end for a ms sql server) But instead of receiving every entry I want to use a filter by a value that is in one of the excel cells. So if in A1 is date 01.01.2000, I want to use this value to only show me all entries by that date
If do not need to use power query if there is an easier way to do it.
Solution 1:[1]
You can pass a value into power query using a table and have your original query reference that cell/table. More detail here: https://exceleratorbi.com.au/pass-excel-parameter-power-query/
Solution 2:[2]
check the sample file, fill the parameters as per your DataBase
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | DKoontz |
| Solution 2 | Umut K |