Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Create a new table in query editor from existing columns?

I have an existing table that was created in Power BI by importing a massive CSV file. I want to create a new table in the query editor so I can pivot two columns, without altering the original data ...
Need Help
  • Pragati11's avatar
    Pragati11
    5 years ago

    Hi Anonymous ,

     

    You can do the following:

    1. Go to Query editor
    2. Right click on the table that you want to copy and select Reference option as shown: 
    3. Once you select REFERENCE a copy of this table will be created in the Query Editor area.

    You can then further use this new table reference to do your transformations.

     

    Thanks,

    Pragati

     

AKNiang's avatar
AKNiang
Frequent Visitor
4 years ago

Duplicate the query create a new query that is identical in step an result to the one you copy from till the step you reached at the moment of copying.

If the original query from which you copied change the copied one won't.

 

Reference a query is like referencing a cell in excel. If the original query change, also the referenced one will.