Forum Discussion

ap's avatar
ap
Icon for Advocate I rankAdvocate I
10 years ago
Solved

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.
Show and Tell
Tips and Tricks
  • TeeGee's avatar
    TeeGee
    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's avatar
michellemetzger
New Member
9 years ago

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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Then don't do it in the query editor. Do it in the table editor. Hit the New Table button in the Modeling tab and Type NewTable = TableName