cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
infantpowerbi Regular Visitor
Regular Visitor

How to copy entire table in power bi

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

3 REPLIES 3
Super User
Super User

Re: How to copy entire table in power bi

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.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
sktneer Frequent Visitor
Frequent Visitor

Re: How to copy entire table in power bi

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 Regular Visitor
Regular Visitor

Re: How to copy entire table in power bi

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

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,592)