Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |