Forum Discussion
Advocate ICopying a data 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.
Advocate IIYour suggestion worked great to copy the table into the current .pbix. Can a DAX generated table be copied to another .pbix?
Helper IIDoes 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.
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.
I have faced scenarios where you would like to do it (the table copy) inside Power Query without waiting for DAX layer.
The copy & past feature, executes again all the steps of the query you are copying, so a lot of unnecessary steps are executed again.
What apparently works to take advantage of previous query results is:
* New Source / Blank Query
* = #"TableToCopyName"
Hope it helps!
If the table is small enough (not more than 3000 cells) you can paste it in the Enter Data tool of PQE. If your table has more cells the answer on creating a new table in PQE with a blank source and typing the table name as a query seems to be a better approach than a copy from the model and paste into PQE. I can see the use case for using either within PBI or externally.
- amirshiloh
seems to me that there is kind of bug when i copy function from one pbix to another pbix : when i did it once - it works correctly, on the second and third times, it copy both the current copy function and the prvevious !!! (create a second copy of the previous which mark with the suffix (2) ) i tried it few times, i tried to close the pbix, i tried to clean the cache (in the options) and still same issue !
anothe issue is that i prevent deleted the sconds copies with msg that it can't be deleted be because these previous copies are related to the new copies tables (there is no relation between them at all !!)
