Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
Anonymous
Not applicable

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
v-chuncz-msft
Community Support
Community Support

@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.
Anonymous
Not applicable

Hi,

 

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

 

Kind regards

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
Not applicable

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

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.