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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
sohananahid
Post Partisan
Post Partisan

Having issue while trying to Duplicate a table: both for table via Direct query or Calculated Table

Hi all,

I am working on a Power BI Report that has a dataset/ table - "Employees", which is a Calculated Table with all the columns are Calculated Columns

To add another page with new functionality- I am connecting to another dataset/table "Event Items" via Direct Query.

-I need to make a duplicate of the "Event Items" table or a duplicate of the "Employees" table.

-I can't do the duplicate of "Event Items" as no option for Copy/ duplicate is available as this is via "Direct Query"

 

My other option is to Copy the "Employees" Table-> but each of the columns in this table are Calculated Column->  Once I select the Table, "Employee"s and do Copy table-> I don't know how to paste [tried Control +V] the entire table into a duplicate/copy of Employees. The only option I see is "New table" and paste the query that shows up for the table- it creates only 1 Column that is defined in the query. Then I have to do "New column" for copying the other Columns in "Employees" to add step by step to make a copy/duplicate of the "Employees" table.

 

is there a 1 step to copy the whole of the "Employees" tables rather than step by step copy and paste with  "Add New Column"?

Many thanks in advance. Ciao, ~reveur007

3 ACCEPTED SOLUTIONS
johncolley
Solution Sage
Solution Sage

Hi @sohananahid , So Duplicate or Reference options aren't available to you? I can use them on Direct Query tables. Alternatively, you could also just add the table from the data source again, then you'll have two copies of the event table. 

johncolley_0-1662681330199.png

 

View solution in original post

MahyarTF
Memorable Member
Memorable Member

Hi,

If you want to copy the table in Power Bi you could in the Data pane use the 'New Table' link :

in the below image I copy the table that is in Direct mode :

[New table Name] = [exist table name]

MahyarTF_0-1662681891367.png

You could do the same for any other storage mode type :

the below is for the import one with calculated Column :

MahyarTF_1-1662681975258.png

Appreciate your Kudos

Mahyartf

View solution in original post

Hi,

If you want to select some of the columns from original Table (for some reason), you could use the Summarize function to copy that :

Sample :

EmployeeCopyTable = SUMMARIZE(Employees,Employees[Name],Employees[Age],Employees[Code],Employees[Desc],Employees[EmpId],Employees[Location])
MahyarTF_0-1662809225622.png

As you see in the Copy Table (that is generated with Summarize), I didn't call the Name-age Column

Please mark my post as a solution if it is answer your question

Mahyartf

View solution in original post

4 REPLIES 4
MahyarTF
Memorable Member
Memorable Member

Hi,

If you want to copy the table in Power Bi you could in the Data pane use the 'New Table' link :

in the below image I copy the table that is in Direct mode :

[New table Name] = [exist table name]

MahyarTF_0-1662681891367.png

You could do the same for any other storage mode type :

the below is for the import one with calculated Column :

MahyarTF_1-1662681975258.png

Appreciate your Kudos

Mahyartf

Hi @MahyarTF,

Thanks for your prompt response. As I tried to copy the Imported table, 'Employees' -I get the error message:

sohananahid_0-1662747608130.png

This error shows up in the original "Employees" table too for that column, FIM_Count- but all the data/records shows up in the "Employees" table, but no records/rows show up in the copy table, "EmployeesCopy"!

To avoid this issue in the copied table-I tried to delete this column in the "EmployeesCopy" table since I don't need that Column/Field for my new page-> but found "Delete" option is disabled!

Any idea how to resolve this issue? Many thanks!

Hi,

If you want to select some of the columns from original Table (for some reason), you could use the Summarize function to copy that :

Sample :

EmployeeCopyTable = SUMMARIZE(Employees,Employees[Name],Employees[Age],Employees[Code],Employees[Desc],Employees[EmpId],Employees[Location])
MahyarTF_0-1662809225622.png

As you see in the Copy Table (that is generated with Summarize), I didn't call the Name-age Column

Please mark my post as a solution if it is answer your question

Mahyartf
johncolley
Solution Sage
Solution Sage

Hi @sohananahid , So Duplicate or Reference options aren't available to you? I can use them on Direct Query tables. Alternatively, you could also just add the table from the data source again, then you'll have two copies of the event table. 

johncolley_0-1662681330199.png

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.