title: Prevent loss of decimal separator when importing CSV in PowerBI
body: <p>I was creating a repro for a different PowerBI question, and crafted this example (UTF-8) CSV in Notepad:</p>
  
  <pre><code>IssueDate,Total,Location
  2017-01-02,29.50,Detroit
  2017-01-03,11.50,Boston
  2017-01-04,13.50,Atlanta
  2017-01-05,13.50,Detroit
  </code></pre>
  
  <p>When I load this into PowerBI as an external datasource I see:</p>
  
  <ul>
  <li>File Origin = "1252: Western European (Windows)"</li>
  <li>Delimiter = "Comma"</li>
  <li>Data Type Detection = "Based on first 200 rows"</li>
  </ul>
  
  <p>Here's a screenshot:</p>
  
  <p><a href="https://i.stack.imgur.com/0RiIo.png" rel="noreferrer"><img src="https://i.stack.imgur.com/0RiIo.png" alt="Same info as above, where &quot;Total&quot; is listed without commas"></a></p>
  
  <p>And after I finish:</p>
  
  <p><a href="https://i.stack.imgur.com/j3qFD.png" rel="noreferrer"><img src="https://i.stack.imgur.com/j3qFD.png" alt="Modeling overview with same data"></a></p>
  
  <p><strong>The problem:</strong> my decimal separators have gone!</p>
  
  <p>I've tried many different solutions:</p>
  
  <ul>
  <li>Changing "File Origin" to UTF-8;</li>
  <li>Changing the source to use semi-colons instead of commas for delimiters (even though in the real case I cannot influence the separator, this was just for testing);</li>
  <li>All options for "Data Type Detection";</li>
  <li>Playing around with the data type for the column in the Query Editor;</li>
  <li>Meticulously going through all the "Transform" options in the Query Editor;</li>
  <li>In response to a comment I've tried quoting my values with <code>"</code> marks but this didn't change anything;</li>
  <li>In response to a comment I've carefully read through <a href="https://msdn.microsoft.com/en-us/library/mt260840.aspx" rel="noreferrer">the <code>Csv.Document(...)</code> documentation</a> (which you can use in the advanced query editor) but found no argument that affects decimal separators or culture settings.</li>
  </ul>
  
  <p>None of this helps.</p>
  
  <p>I'm almost afraid to ask... but does my Windows region ("Dutch") have an influence here? And if so: how can I go around that? Because the data might be refreshed and/or the report might be edited by others that have other regional settings on their PC.</p>
  
  <p><strong>How do you get PowerBI to respect the decimal separator in CSV numeric values?</strong></p>