Copy Table to Excel: All Data Crammed in One Column

[Anonymous]

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.

[Anonymous]

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]

I am having the same issue , please advise? 

I was able to copy table previously .

[Anonymous]

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]

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!

[v-yuta-msft]

@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 · Accepted solution]

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

[Anonymous]

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! 

[v-yuta-msft]

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