title: Import custom Atom feed in PowerPivot
body: <p><strong>Question:</strong> I have created a sample xml document containing data conforming to the atom 1.0 schema. When I import the contents of this file (for testing purposes) in PowerPivot, it creates columns for each atom element in each entry, instead of creating a column per content element. Why is this?</p>
  
  <p><strong>Background:</strong> A customer wants to import data from a web service which provides a feed that uses a custom XML schema that is not supported by PowerPivot. The service provides the ability for the caller to supply an XSLT template that will be applied to the feed. I am hoping to be able to transform this feed into a valid atom feed thereby allowing the customer to import data into PowerPivot.</p>
  
  <p><strong>Sample atom xml:</strong></p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;feed xmlns:d="http://schemas.microsoft.com/ado/2007/08/dataservices"
        xmlns="http://www.w3.org/2005/Atom"
        xmlns:m="http://schemas.microsoft.com/ado/2007/08/dataservices/metadata"&gt;
     &lt;title type="text"&gt;My Data Feed&lt;/title&gt;
     &lt;id&gt;http://temp/feed&lt;/id&gt;
     &lt;updated&gt;2012-12-13T00:00:00Z&lt;/updated&gt;
     &lt;entry&gt;
        &lt;id&gt;http://temp/feed/1&lt;/id&gt;
        &lt;title type="text"&gt;Title&lt;/title&gt;
        &lt;author&gt;
           &lt;name&gt;Author&lt;/name&gt;
        &lt;/author&gt;
        &lt;updated&gt;2012-12-13T00:00:00Z&lt;/updated&gt;
        &lt;content type="application/xml"&gt;
           &lt;d:Name&gt;John Smith&lt;/d:Name&gt;
           &lt;d:Address&gt;Address&lt;/d:Address&gt;
           &lt;d:Zip&gt;1234&lt;/d:Zip&gt;
        &lt;/content&gt;
     &lt;/entry&gt;
  &lt;/feed&gt;
  </code></pre>
  
  <p>When imported into PowerPivot (selecting "From Data Feeds", clicking "Browse" and pointing out the xml file), it looks like this:</p>
  
  <p><img src="https://i.stack.imgur.com/7ezIj.jpg" alt="PowerPivot import result"></p>
  
  <p>I was excpecting three columns: Name, Address and Zip. If I change "Include Atom Elements" from <strong>Auto</strong> to <strong>False</strong> in the connection configuration, no columns are imported.</p>