Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
DataData2
New Member

Export data tips

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

 

 

 

 

 

0 REPLIES 0

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors