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