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'...
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.

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!