Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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?
Solved! Go to 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
You may right click on the cell and select Paste Options.
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
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
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
77 | |
74 | |
57 | |
38 | |
33 |
User | Count |
---|---|
70 | |
63 | |
55 | |
48 | |
46 |