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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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