An alternative option is to utilise FILTER function - create dummy worksheet for this purpose, use FILTER and reference the whole worksheet where your source data sits. The result of the FILTER function is an array, which can be fed to Power Query without converting to table. The worksheet with FILTER function can be hidden, as it's sole purpose is to keep live connection to source and convert it to an array that feeds into Power Query.

I sometimes use this method with additional benefit of being able to apply filters in excel function before feeding to PQ (e.g. when I know I'm only interested in nonempty cells in a column). There's a downside to this method though - the filtered range cannot contain an error, since this will result in the whole array returning an error...