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.
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
Community Championmichellemetzger 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)
jhauff77060Advocate II
Your suggestion worked great to copy the table into the current .pbix. Can a DAX generated table be copied to another .pbix?
TeeGeeHelper II
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.
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.
