title: Connecting to 4D database in Power BI via ODBC
body: <p>Has anyone tried connecting to a 4D database from Power BI? I keep getting this error when I try to connect.</p>
  
  <pre><code>The field `Field Name` already exists in the record.
  </code></pre>
  
  <p>What's happening is that the 4D database columns all have spaces in there. I think that's causing the problem, maybe Power BI just reads the part before the space and saw another field with the same name before the space. E.g. "School Name" and "School Address". </p>
  
  <p>Is there anyway to get around this? Due to this error PowerBI won't load the data.</p>