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

[sohananahid]

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

[johncolley · Accepted solution]

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. 

[MahyarTF · Accepted solution]

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]

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

the below is for the import one with calculated Column :

Appreciate your Kudos

[MahyarTF · Accepted solution]

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]

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

the below is for the import one with calculated Column :

Appreciate your Kudos

[sohananahid]

Hi @MahyarTF,

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

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!

[MahyarTF · Accepted solution]

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

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

[johncolley · Accepted solution]

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.