Power bi copy entire table to excel, all data crammed in one column

[shwong]

Dear community,

hope all is good! I would like seek your support to fix the following issues:

Its a part of my daily rountie to refresh the latest YTD transactions to track the business, the sample size is around 7k transactions as per a week ago, and it was completely working fine when I tried to use the "Copy entrie table" function and paste the data to the excel file, without all the data crammed in a column. The BI deskstop was smart enough to paste the data into individual columns.

However, this morning I tried to perform the same and the sample size get close to 8k transactions. The copy and paste was failed, all the data crammed into one column with even having the delimiter, thus I could not further use the text to columns function to fix the issues, which makes this meaningless.

I read a old post related to the same issues, but no solution was given.

I even tried to sugguest in below post, try to apply the filters to select a smaller data group, and of course it works and all the data did not crammed into one column. However I can not be bother to test out the solution as I might have to end up doing the extraction for multiple times before finsihing off the whole entrie data set.

https://community.powerbi.com/t5/Desktop/Copy-Table-to-Excel-All-Data-Crammed-in-One-Column/m-p/6355...

May I check if the comunity here if everyone else are facing the same issues? is there a bug in the BI desktop? and do we need to install the latest update to fix this?

Regards

Tom

[Jill_Mc]

When doing the LinkedIn Learning Power BI Essential Training by Gini von Courter, it asks you to copy a table directly from MS Word into PowerBI in the "Manually Enter Data" function when you create a new project. This fails and all data is crammed into one column. A workaround is to copy and paste the table into MS Excel and then save as a .csv file, then copy and paste the data into PowerBI.  This will help you workaround to continue the Power BI Training.

[v-xulin-mstf]

Hi @shwong,

Is your issue solved?

If the issue has been solved, please share the solution and adopt it to help others.

Thanks! 😉

Best Regards,
Link

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

[v-xulin-mstf · Accepted solution]

Hi @shwong,

I can't reproduce your issue in my environment, it works well in my environment.

You can try to  install the latest update and check.

As a workaround, you can also use Text to column function in excel.

Best Regards,
Link

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

[PaulDBrown]

You can save a table visual to a CSV file if that helps

[shwong]

HI Paul, thanks for the feedback. but this is not the data extract from the visual, is direct copy from the raw data tabe. it just combined with in the same column without delimiter.

Regards

Tom