Forum Discussion
Solved
Copying data from a Matrix into excell
Hey Guys, i'm hoping you can help me here I have a dashboard containing a matrix and I want people to copy the data from that matrix and pasting it in excel. That is not necesarrily the problem ...
Anonymous there is no solution to my problem so I had to fix it in an ugly way and that is to replace the , with a | (comma for a pipe)
Hey there!
When copying data from a Power BI Matrix and pasting it into Excel, columns containing commas (e.g., comments) are being split into multiple columns instead of staying as a single column. Excel treats commas as delimiters (especially in CSV-like data). When pasting, Excel automatically assumes a comma-separated format and splits data into multiple columns.
You can try this easy fix:
Use Notepad as an Intermediate Step (Quick Fix)
Copy the data from Power BI.
Paste it into Notepad (this removes formatting).
Copy again from Notepad and paste it into Excel.
Hope this helps!
😁😁