Using Excel Column in SQL queries through Power Query

[GBilianis]

Hello. I am not sure if this is the right group for this question. Anyway, I was wondering if it's possible to run SQL query, using a column from an excel as parameter, on an excel file. for example: Select * from (excel column) a inner join (Sql.table.column) b on a.column1 =b.column2. I want to run this using excel power query, if possible.

 

[ExcelToDAX]

Yes there is a way. You can't directly do it within the "Insert SQL Statement", but after you load the SQL statement, you will notice that it posts the SQL code in the formula bar. All you have to do is close the quotation, and then put " & Query1 & " like the screenshot posted.

 

[GBilianis]

Thanks a lot for your reply. I will try it tomorrow, since it's a work thing. I would like to know if it has to be in the same sheet that you run the query, or you can use another sheet's values