Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
If your client machine has regional setting with delimiter-value set to a value other than a comma (,), Export data feature might not work well.
It turns out Excel decides to use-regional-setting delimiter instead of a comma as the delimiter for a CSV (Comma separated value) files. I am not really sure what is the reason.
To work around this issue, there are 2 options
Option 1: change your regional setting in your local machine
Go into control panel -> Regional settings -> Advanced Setting and change your list separator to a comma
Option 2: Open the CSV file in a text editor; specify the delimiter value by adding the following in a new line (top of the file content):
sep=,
NOTE: the instruction is specific to Excel App only and it is not a CSV standard; so other CSV editor might not like it.
hope this helps
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.