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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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