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

     

Pragati11's avatar
Pragati11
Icon for Super User rankSuper User
5 years ago

Hi Anonymous ,

 

Refrencing a table doesn't create a complete copy of the table from memory point of view and doen't take any extra power BI storage. Therefore it is always good to refrence a table rather than using Duplicate. So good to use the earlier option.

You can remove the columns which are not required.

 

Thanks,

Pragati