+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    Forum Contributor
    Join Date
    10-02-2013
    Location
    Harrisburg, PA
    MS-Off Ver
    Office 365 MSO (16.0.10730.20264) 32-bit
    Posts
    159

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

    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
    Please Login or Register  to view this content.
    Thanks

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

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

    Try something like this:
    Please Login or Register  to view this content.
    Is that something you can work with?
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Adding manual data to a power query?
    By S7ewie in forum Excel General
    Replies: 20
    Last Post: 01-19-2019, 08:44 AM
  2. Replies: 1
    Last Post: 11-12-2018, 02:46 PM
  3. Power Query: Using a Parameter to specify a source table name.
    By learning new things in forum Excel General
    Replies: 0
    Last Post: 11-06-2018, 04:21 PM
  4. Replies: 5
    Last Post: 06-29-2018, 05:35 AM
  5. Power Query - Parameter not working
    By vibajajo64 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 04-20-2018, 01:08 AM
  6. Power Query Source vs Different PCs
    By flpneves in forum Excel General
    Replies: 1
    Last Post: 12-05-2017, 01:07 PM
  7. Dynamic Parameter Using Power Query
    By NeedForExcel in forum Excel General
    Replies: 1
    Last Post: 06-16-2016, 02:51 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1