title: Import simple XML into Power BI
body: <p>I am trying to import this simple XML data into Power BI (or Excel 2016): </p>
  
  <p><a href="https://resourcescrono.s3-eu-west-1.amazonaws.com/demo-biblio.xml" rel="nofollow noreferrer">https://resourcescrono.s3-eu-west-1.amazonaws.com/demo-biblio.xml</a></p>
  
  <p>It's a simple XML, with a 3 column table (it even has the XSD schema attached). The same XML can be easily imported in former Excel versions (Excel 2003 and so on).</p>
  
  <p>However, Power BI and Excel 2016 fails in multiple ways:</p>
  
  <ul>
  <li>It seems to ignore schema data</li>
  <li>It fails to detect invariant number formats.</li>
  </ul>
  
  <p>How can get this data into my Power BI dashboard or Excel 2016?</p>
  
  <p><img src="https://i.stack.imgur.com/R8Pvi.png" alt="Power BI screenshot"></p>
  
  <p>My regional settings are spanish, but I don't know the regional setting of my users (may vary). </p>
  
  <p><strong>UPDATE</strong>: Microsoft has accepted it as a bug. Excel should respect XSD schema: <a href="https://community.powerbi.com/t5/Issues/Bug-importing-simple-XML-file/idc-p/429822" rel="nofollow noreferrer">https://community.powerbi.com/t5/Issues/Bug-importing-simple-XML-file/idc-p/429822</a> </p>