Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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 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

 

 

1 ACCEPTED SOLUTION
Pragati11
Super User
Super User

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: Pragati11_0-1615303210018.png
  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

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

View solution in original post

4 REPLIES 4
AKNiang
Frequent Visitor

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
Super User
Super User

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

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Pragati11
Super User
Super User

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: Pragati11_0-1615303210018.png
  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

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Anonymous
Not applicable

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.