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.
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.
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!