Forum Discussion
Having issue while trying to Duplicate a table: both for table via Direct query or Calculated Table
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
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