Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Copy Table to Excel: All Data Crammed in One Column

When I copy this table from my data in Desktop:

 

 

All the data appears in one column in Excel:

 

This makes copying the data useless - I need the same columns I had in Power BI. I've successfully copied data from tables before. Is this an issue with the file size? Is there an easy workaround? I've been rebuilding tables in the Report view to export the data, but there should be a better solution.

Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Issue is not solved, but I'm circumventing it using the table visual on a page.

9 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    Anonymous ,

     

    Couldn't reproduce your issue. Copy table works well on my side. Just select the first cell on the left-top of excel sheet and paste the table.

     

    Community Support Team _ Jimmy Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    Anonymous ,

     

    Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.

     

    Regards,

    Jimmy Tao

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Issue is not solved, but I'm circumventing it using the table visual on a page.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi! I know this is an old thread, but when you paste the data in to excel and it ends up all in one column, you can do Data > Text to Columns > then pick Delimited > and select Tab as the delimiter.  It will put all of the columns from your PowerBI table into separate columns in the excel file.  You don't see the tabs when you paste, but they are there.  Please mark this as a solution if it works for you! 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I am having the same issue , please advise? 

    I was able to copy table previously .

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I just discovered that I have the same issue. I was able to copy table before, and now it's not working 😞

      Does anyone have any solution?

       

      Thanks!

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        It seems there is a limitation in size of the table. I just tried to filter for smaller data sets and in that scenarion copy table works - it actually paste it correctly in excel.

        Hope it helps!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    I have a simmilar issue. Even if I try circumvent it using the table visual on a page the selected data is pasted in one column, without delimiter, which make it pretty useless 😞

     

    The strange thing is that it has worked before for me (just like in Anonymous 's case).

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    This also occurs in the opposite direction.  When copying a table from MS Word into Power BI (as shown in LinkedIn Learning Power BI Essential Training by Gini Von Coutier), all data is crammed into one column. I worked around this by copying the MS Word Table into MS Excel, saving as .csv, and then copy and paste into PowerBI.