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.

CodePudding user response：

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/