Hi.

In power query, how can I have a value from a manual table be used in the source sql of another query or from a cell in the current workbook???
Table is on an SQL Server. For Business unit, I would like the 'ABC' to be read from either a cell in excel or in a manually entered table in power query...

Source SQL
select Projects_SV.*
FROM Projects_SV
Where Projects_SV.[Business_Unit_ID] = 'ABC'
Thanks