Create a new table in query editor from existing columns?

[Anonymous]

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 table

If I simply create a new table in DAX, it will not let me pivot the columns in the query editor

How can I simply create a new table in the query editor from an existing table, with several columns?

Original table: table1 
Columns I want: rowID, status change date, process step

[AKNiang]

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.

[Pragati11]

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

[Pragati11 · Accepted solution]

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

[Anonymous]

Thank you -- worked perfectly. How is referencing different than copying the table? or is it the same?