Error when using "Copy Table" to Excel

[rvcedd]

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?

[v-chuncz-msft]

@rvcedd 

You may right click on the cell and select Paste Options.

[Anonymous]

Hi,

Can you give an overview of the format applied in each column in the query?

Kind regards

[rvcedd]

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

[Anonymous · Accepted solution]

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 

[Tad17]

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.