cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rvcedd Helper I
Helper I

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?

 

CopyTable1.PNG

 

CopyTable2.PNG

 

CopyTable3.PNG

 

 

 
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Maxim297
Frequent Visitor

Re: Error when using "Copy Table" to Excel

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 Capture.PNG

View solution in original post

5 REPLIES 5
Maxim297
Frequent Visitor

Re: Error when using "Copy Table" to Excel

Hi,

 

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

 

Kind regards

rvcedd Helper I
Helper I

Re: Error when using "Copy Table" to Excel

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

 

Tad17 Solution Sage
Solution Sage

Re: Error when using "Copy Table" to Excel

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.

Highlighted
Maxim297
Frequent Visitor

Re: Error when using "Copy Table" to Excel

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 Capture.PNG

View solution in original post

Community Support
Community Support

Re: Error when using "Copy Table" to Excel

@rvcedd 

 

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors