Power Query SQL (Source) run with manual table parameter?

**Steveapa** · 01-28-2019, 11:27 AM

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

**Ron Coderre** · 01-28-2019, 09:03 PM

Try something like this:

let
    paramBusUnit = "North",
    txtBaseSQL = 
        "select Projects_SV.*
        FROM Projects_SV
        Where Projects_SV.[Business_Unit_ID] = 'ABC'",
    txtSQL = Text.Replace(txtBaseSQL, "ABC", paramBusUnit)

in
    txtSQL

Is that something you can work with?

Power Query SQL (Source) run with manual table parameter?

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Power Query SQL (Source) run with manual table parameter?

Re: Power Query SQL (Source) run with manual table parameter?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Adding manual data to a power query?

How to create dynamic source for a pivot table from a append table in power query

Power Query: Using a Parameter to specify a source table name.

Excel Power Query- The headers from the CSV source table can change.

Power Query - Parameter not working

Power Query Source vs Different PCs

Dynamic Parameter Using Power Query

Bookmarks

Bookmarks

Posting Permissions