Forum Discussion
Error when using "Copy Table" to Excel
Hello there,
I am trying to use the "Copy Table" feature in PowerBI but when pasting the informatio into Excel 2016 I get an error. Please see the 3 screenshots below. Any advice on what might be going wrong?
- Anonymous6 years ago
Hi,
When your travel_date column has the date format, it don't give an error anymore and is it possible to copy it in excel.
See attachment: https://1drv.ms/x/s!AnMfHjVH-L0vjetx3BhYOauMiRYG3w?e=BlkbsT
5 Replies
- v-chuncz-msftCommunity Support
- AnonymousNot applicable
Hi,
Can you give an overview of the format applied in each column in the query?
Kind regards
- rvceddHelper I
Hey - I've uploaded the pbix file to onedrive below.
The error occurs when trying to "Copy Table" on train_revised_joined
https://1drv.ms/u/s!Avv4DxzuMuq2kcII6TAfd0OqCQYiXg?e=rjEDah
- AnonymousNot applicable
The easy workaround solution is to create a table visual with all of the rows and then just export that table visual as a CSV file from the triple dots on the visual.