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.

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
10 years ago

Hi ap

 

If you want a duplicate your Data Table.

 

Go to Query Editor

 

And rightclick to the table and choose duplicate.

 

sdjensen's avatar
sdjensen
Icon for Solution Sage rankSolution Sage
10 years ago

If you want to copy it to another PBI Desktop file you can follow these steps...

 

1. In the model where you have your table go to Query Editor

2. Highlight your query that creates the table and ctrl+c

3. Open a new PBI Desktop file and go to Query Editor

4. Right-click in the queries pane and paste.

  • CatPhish's avatar
    CatPhish
    Icon for Advocate I rankAdvocate I
    7 years ago

    This is great.  Worked like a charm, thank you.