How to copy entire table in power bi

[infantpowerbi]

Dear All,

I have table in my powerbi file which consists of some meassures, calculated coulmns .
And I would like to copy the same table and remove the content so that i can map to another table to excel file
which is holding same columns and that also requires same meassures and calculated columns.

Can any one please help me in knowing how can I make it

[sktneer]

As Ashish suggested, open the Edit Query window, duplicate your table by right clicking table query and choose Duplicate, rename it and then change the path to point to your new table in the first step Source.

[infantpowerbi]

Tq for your response, I have table in same excel book in another sheet,So unable to import the file or sheet

[Ashish_Mathur]

Hi,

When you click on the Edit Queries button, double click on Source in the APplied steps pane on the right and point to the new Excel file.