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"

     

     

MarcelBeug's avatar
MarcelBeug
Community Champion
8 years ago

Yes, create a third query.

 

Additionally you may want to uncheck "Enable Load" for your first table that has all columns.

 

abond's avatar
abond
Frequent Visitor
8 years ago

I believe you're recommending that I load the data twice from the source, and that is what I'm doing currently, but it's inefficient and undesirable due to the volume of data.

 

My ideal solution would involve loading the data once then duplicating within the Query Editor. :-)