Martin
Martin

Reputation: 19

Exportin data from Power BI

I am exporting data from Matrix in Power BI to excel (csv). The problem is that these data are showing in excel in one column separated by commas. My colleagues don't have this issues. If they export data they are separated into columns based on header in matrix. Where should I fix this? Is it some Power BI settings or excel? I don't want to always use text to columns because (use comma as separator), because my $values are messed up.

Thanks

Upvotes: 0

Views: 1667

Answers (2)

Murray Foxcroft
Murray Foxcroft

Reputation: 13745

Change the regional settings in the PowerBI file.

Click File->Options and Settings->Current File->Regional Settings and adjust accordingly.

enter image description here

Upvotes: 1

Martin
Martin

Reputation: 19

I solved it by Changing Regional Setting in Windows.

Upvotes: 0

Related Questions