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"

     

     

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]