Forum Discussion
Copying data from a Matrix into excell
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)
Hi RonaldvdH ,
When copying data in Power BI and pasting it into Excel, commas can cause column separation issues. There is no direct setting in Power BI itself to resolve this issue, you could try the following methods:
1. Use a semicolon or other separator: In Power BI, when exporting data to a CSV file, you can choose to use a semicolon or other separator instead of a comma. This prevents Excel from mistaking commas for column separators.
2. Use Excel's Text Import Wizard: After pasting data in Excel, you can use the Text Import Wizard to manually specify separators.
3. Preprocessing data in Power BI: In Power BI, you can use DAX or Power Query to preprocess data and convert columns containing commas to other formats.
4. If you need to export data frequently, consider using Power BI's export feature to export the data to an Excel file. This ensures that the data is properly disaggregated when exported.
Best regards,
Lucy Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous I'm not actually exporting the data because i'm using a Dashboard. I can only copy/paste the data into excel and then Excel 'thinks' the comma's are a delimiter.
If there is no setting to change this behaviour the only option I have is to replace the , with an | (or something else)
The option mentioned by freginier would have been a nice 'cheat' but unfortunately that didnt'work (just yet)