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.

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

If you are talking about a Visualization Table use => Ctrl+C (Copy) and then Ctrl+V (Paste)

 

EDIT: I guess I didn't read the whole question

 

In the Query Editor => on the Home tab => click New Source => select Blank Query => in the formula bar type => = tablename

 

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

  • Sean's avatar
    Sean
    Icon for Community Champion rankCommunity Champion
    9 years ago

    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)

     

    • jhauff77060's avatar
      jhauff77060
      Icon for Advocate II rankAdvocate II
      8 years ago

      Your suggestion worked great to copy the table into the current .pbix. Can a DAX generated table be copied to another .pbix?

      • TeeGee's avatar
        TeeGee
        Icon for Helper II rankHelper II
        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.