Forum Discussion
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'...
Issue is not solved, but I'm circumventing it using the table visual on a page.
Issue is not solved, but I'm circumventing it using the table visual on a page.
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!