Forum Discussion

operator's avatar
operator
Frequent Visitor
10 years ago
Solved

New table / query based on existing query

Hi, still new to Power BI migrating from Power Query.   In Power Query we have the capability to use existing query / table and build new query / table. But it doesn't seem to work in Power BI: I c...
Need Help
  • pqian's avatar
    pqian
    10 years ago

    operator, PowerBI Desktop uses PowerQuery internally, so the capabilities are almost identical (Save a few Excel related features)

     

    You can refer to another query by their name, for example, starting from a Blank Query, type

    = Query1

     

    that will refer to an existing query called "Query1"

     

     

pqian's avatar
pqian
Microsoft Employee
10 years ago

operator, PowerBI Desktop uses PowerQuery internally, so the capabilities are almost identical (Save a few Excel related features)

 

You can refer to another query by their name, for example, starting from a Blank Query, type

= Query1

 

that will refer to an existing query called "Query1"

 

 

  • pqian's avatar
    pqian
    Microsoft Employee
    10 years ago

    BTW, if you right click on "Query1", you can pick "Reference Query" from the context menu to do exactly this

    • operator's avatar
      operator
      Frequent Visitor
      10 years ago

      Lovely! That's even easier! Gee I should've asked earlier here than finding the solution for many hours in Google.

       

      Thanks again for your help!

  • operator's avatar
    operator
    Frequent Visitor
    10 years ago

    Thanks pqian! Another dumb question: if the earlier query has space, how do I refer it?

    • pqian's avatar
      pqian
      Microsoft Employee
      10 years ago

      operator You can qualify identifiers by using the #"" escape

       

      e.g.,

      =#"Query 1"

      • emoroz's avatar
        emoroz
        Frequent Visitor
        7 years ago

        Source=#"Query Name"

         

        How do I make the query name a variable based on a cell selection? 

         

        Below TemplateType is the name of query loaded into table. The custom function loads that query into another query. I want to do the same thing except I don't want the data to be loaded into a table. 

         

        Excel.CurrentWorkbook(){[Name=TemplateType]}[Content]