ROOKIE here with (hopefully) simple request

[DriveAnywhere]

First off I apologize for the lack of detail, this is for work so I cant give exact info on variables etc. Also I am new to PowerQuery.

I have established my ODBC connection (=Odbc.Query("dsn=private", "Select#(lf)variable1, ...")

so: (Select x, y From z Where x in ('')) and I would like to merge with a named range of x to return y values from the ODBC connection.
So ultimately what I hope to achieve is (Select x, y From z Where x in (Named Range))

My named range is a list of over 12,000 (x) items. They have all been appropriately formatted with 'x', so that they can be used in a SQL query, the last x has had its comma removed as you would in a typical SQL query.
The name I have given this list is literally LIST... I tried using {[Name="LIST"]} within the parentheses and that didnt work, so I tried the fuller =Source{[Name="LIST"]}[Content] and that also didn't work.

Can anyone tell me where I'm going wrong here? I spent the last few days trying to achieve this in VBA which was a nightmare...hoping I'm on the right track here.