Forum Discussion
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
Hi Anonymous , 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.
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
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
4 Replies
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
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!
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
Hi Anonymous , 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.