cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ap Advocate I
Advocate I

Copying a data table? I see the copy function when I right click on a table but how do I paste this?

I am looking to copy a data table but can't seem to find out where and how I can paste this?

 

I've created a datedimension table but would like to repurpose it.

1 ACCEPTED SOLUTION

Accepted Solutions
TeeGee Helper II
Helper II

Re: Copying a table? I see the copy function when I right click on a table but how do I paste this?

Does anyone know definitively whether this is possible?

 

If it isn't possible to paste a table, then what is the point of the "Copy Table" menu item?  Is this a feature that was accidentally left  unfinished?

 

UPDATE:  Ok, the purpose of that is so you can paste into an external app like Excel.

 

The only way to reuse a DAX based table, and preserve post creation configuration like setting of sort columns, formats, etc is to use the PBIX file as a starting point for all new projects.  If you've started without doing that, you can create a new table in the destination and paste in the DAX, but you'll have to redo those customization tasks.

View solution in original post

15 REPLIES 15
Sean Community Champion
Community Champion

Re: Copying a table? I see the copy function when I right click on a table but how do I paste this?

If you are talking about a Visualization Table use => Ctrl+C (Copy) and then Ctrl+V (Paste)

 

EDIT: I guess I didn't read the whole question

 

In the Query Editor => on the Home tab => click New Source => select Blank Query => in the formula bar type => = tablename

 

Vvelarde Community Champion
Community Champion

Re: Copying a data table? I see the copy function when I right click on a table but how do I paste t

Hi @ap

 

If you want a duplicate your Data Table.

 

Go to Query Editor

 

And rightclick to the table and choose duplicate.

 

diplicate.png




Lima - Peru
sdjensen Solution Sage
Solution Sage

Re: Copying a data table? I see the copy function when I right click on a table but how do I paste t

If you want to copy it to another PBI Desktop file you can follow these steps...

 

1. In the model where you have your table go to Query Editor

2. Highlight your query that creates the table and ctrl+c

3. Open a new PBI Desktop file and go to Query Editor

4. Right-click in the queries pane and paste.

/sdjensen
michellemetzger
New Member

Re: Copying a table? I see the copy function when I right click on a table but how do I paste this?

I am having this same issue however your suggestion of creating a new query with =tablename does not work.

 

I created the original table using the DAX Calendar function so there is no query behind it.

 

Please help.

 

Thanks

Super User I
Super User I

Re: Copying a table? I see the copy function when I right click on a table but how do I paste this?

Then don't do it in the query editor. Do it in the table editor. Hit the New Table button in the Modeling tab and Type NewTable = TableName


Did I answer your question? Please mark it as a solution.

Proud to be a Datanaut!
Sean Community Champion
Community Champion

Re: Copying a table? I see the copy function when I right click on a table but how do I paste this?

@michellemetzger Yes this has always been a one way street - you can't access any DAX generated tables in the Query Editor!

 

If you do want to copy a DAX generated table (as @KHorseman said)

 

New DAX Table.png

jhauff77060 Advocate I
Advocate I

Re: Copying a table? I see the copy function when I right click on a table but how do I paste this?

Your suggestion worked great to copy the table into the current .pbix. Can a DAX generated table be copied to another .pbix?

TeeGee Helper II
Helper II

Re: Copying a table? I see the copy function when I right click on a table but how do I paste this?

Does anyone know definitively whether this is possible?

 

If it isn't possible to paste a table, then what is the point of the "Copy Table" menu item?  Is this a feature that was accidentally left  unfinished?

 

UPDATE:  Ok, the purpose of that is so you can paste into an external app like Excel.

 

The only way to reuse a DAX based table, and preserve post creation configuration like setting of sort columns, formats, etc is to use the PBIX file as a starting point for all new projects.  If you've started without doing that, you can create a new table in the destination and paste in the DAX, but you'll have to redo those customization tasks.

View solution in original post

turtleseatpizza
New Member

Re: Copying a table? I see the copy function when I right click on a table but how do I paste this?

Click "new table" under the "modeling tab" under data.  When you're there, it prompts you to name the table.  Name it the same name as the table you wish to copy. It gives you the options of different formulas, but when you start to name it the same as the table you're trying to copy, it should show up and you click on that. Then you'll have a complete copy of the same data table.  Just worked for me.

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors