Forum Discussion
Copying a data table? I see the copy function when I right click on a table but how do I paste this?
- 8 years ago
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.
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 Anonymous said)
Your suggestion worked great to copy the table into the current .pbix. Can a DAX generated table be copied to another .pbix?