Forum Discussion
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.
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.
17 Replies
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.
This is great. Worked like a charm, thank you.
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
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
Hi ap, turtleseatpizza, TeeGee, jhauff77060, Sean
I think Copy Entire table feature is not working as per my search over all Power Bi Desktop application. (As i did not find any paste option there.)
But for copy paste below images will explain copy -- paste table.
Copy table (Right Click)Paste (Right Click)
Copy and Paste are usually reserved in program design for cases where you want to paste the data to a certain location. That doesn't really fit what you're trying to do. A table doesn't go anywhere in particular in your data model; it simply exists in your data model. You can't paste a table into another table because that's not how database queries work. This isn't Excel. If you're trying to add the data from one table onto the end of another existing table, you would use the Append function in the query editor, not paste. If you simply want to make a whole copy of the table as a new table, you can use either Duplicate or Reference. Duplicate allows you to go back and make changes to the original query, Reference simply makes a copy by pointing at the original. If you want to add Table A to Table B as new columns rather than new rows, that's a Merge function.
I think everyone is just geting hung up on the terms "copy and paste" rather than looking for the functionality they're trying to get. The functionality exists. It just has a different name than you're expecting.
