SSRS - Query returns empty column from web service when parsing multiple <xml> levels

Question

My SSRS query returns an empty column instead of the actual values when I run the query in Query Designer, using my XML based Dataset pointing to a web service.

The actual xml response has multiple element levels and I am trying to view results from more than one level. It works for some levels but not others. The response XML is structured like this -

<ResponseXML>
 <Entity>
  <Category>AAA</Category>
  <Members>
   <Member>
    <Attributes>
     <Attribute><Name>Att1</Name><Value>Val1</Value></Attribute>
     <Attribute><Name>Att2</Name><Value>Val2</Value></Attribute>
    </Attributes>
    <MemberId>
     <Id>1</Id><Val>Member1</Val>
    </MemberId>
   </Member>
   <Member>
    ...
   </Member>
  </Members>
 </Entity>
 <Entity>
   ...
 </Entity>
</ResponseXML>

The ElementPath in my query is -

 <ElementPath IgnoreNamespaces="True">
  ResponseXML{}/Entity{Category}/Members{}/Member{MemberId{Id,Val}}/Attributes{}/Attribute{Name,Value}
  </ElementPath>

The query returns the correct number of rows, and correct values for columns "Category", "Name" and "Value", but columns "Id" and "Val" are empty.

However, if I change the ElementPath so we stop at the Member level -

ResponseXML{}/Entity{Category}/Members{}/Member{MemberId{Id,Val}}

• the Id and Val columns are populated correctly.

Please help!