Copy Selection Issues

[rtribo]

Hello, 

Recently it has been added the option of copying data from a table/matrix from a report to other tools like Excel. It seemed to work fine but some issues appeared when working with it : 

1- We found out that the data of the empty cells with number format is pasted as "(In blank)", it would be better to paste a "0". 

2- Also found necessary to take into account the country configuration in order to add a dot or a comma for decimal numbers, because now it always adds a dot and may not be useful in Excel.

3- Last issue, when working with a table/matrix which has empty columns used as separators and if the format of these columns' fields are strings (" "), it always gives an error when trying to copy the selection of the table. Nevetheless when the format is a number ("0") it gives no error. It may allow to copy either of the formats. 

If anyone know how to fix any of these issues please comment below. 

Thank you, 

rtribo

[v-qiuyu-msft]

Hi @rtribo,

For the first two issues, please post your feedback in Comment section of this blog: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-september-2018-feature-summary/#copy, or post a idea in ideas forum: https://ideas.powerbi.com/forums/265200-power-bi-ideas

Regarding the issue 3, please share some screenshots to clarify the issue. It would be better if you could share a sample pbix file. 

Best Regards,
Qiuyun Yu 

[Anonymous]

Hello,

Even I am facing issues with the copy selection option. 

It is working randomly but not always, then too not able to copy whole data. 

Is there any way by which I can copy the whole data in the presented format (Suppose I am using a matrix visual so whole data gets copied in matrix format) without using the export data option. 
Any help would be highly appreciated.

Regards
Shrihari