Copy Selection button issue powerbi.com

[Tatmel]

Hi,

I faced with issue when I copy from table/matrix figures and paste to Excel. It works incorrectly if regional system settings of displaying figures are different from powerbi settings. As an example I copy figure 1,100 (one thousand one hundred) from pbi and paste it in Excel 1,1 (one point one). It's confusing. In order to paste it correctly I need to change  cell format of Excel as a text , paste it and replace "," to " " as my system settings looks like this 1 100

[v-yuezhe-msft]

@Tatmel ,

---

@Tatmel wrote:

It works incorrectly if regional system settings of displaying figures are different from powerbi settings. As an example I copy figure 1,100 (one thousand one hundred) from pbi and paste it in Excel 1,1 (one point one). It's confusing. In order to paste it correctly I need to change  cell format of Excel as a text , paste it and replace "," to " " as my system settings looks like this 1 100

---

What are your regional system setting and Power BI settings? Based on my understanding , this is an expected result as Excel inherits your regional system setting.

In addition, what is the result when you use "Export data" option to export data to Excel?





Regards,
Lydia