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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello,

 

You can create a new table and enter sonething like:  table bis = table.

Doing that you can use table bis as any other and data request is the same for both table.

 

Yours sincerely