2.7.1.1 OfficeDataConnection (Office Data Connection)

Child element	Meaning
SourceFile	Specifies the Uniform Resource Locator (URL) to the data source file.
Connection	Specifies the settings for the data connection (1). If two Connection elements are present, the first specifies the preferred connection (1), and the second specifies an alternative in cases where the first cannot be used.
PowerQueryConnection	Specifies the settings only for the Get & Transform data connection (1). If this element is present, more than one Connection element MUST NOT be present. If a Connection element is present, that Connection element SHOULD be ignored unless the application does not support loading ODC files containing a Get & Transform data connection (1).
PowerQueryMashupData	Specifies the settings for the Get & Transform queries that are associated with the Get & Transform data connection (1). This element MUST be present if and only if a PowerQueryConnection element is present. These settings are represented by an XML file that is HTML encoded inside this child element. This XML is specified in [MS-QDEIF].

The following XML schema fragment defines this element.

 <?xml version="1.0" encoding="utf-8" ?>
 <xs:schema
   targetNamespace="urn:schemas-microsoft-com:office:odc"
   elementFormDefault="qualified"
   xmlns="urn:schemas-microsoft-com:office:odc"
   xmlns:xs="http://www.w3.org/2001/XMLSchema">
  
   <xs:element name="OfficeDataConnection">
     <xs:complexType>
       <xs:sequence>
         <xs:element name="SourceFile" minOccurs="0" type="xs:string" />
         <xs:element name="Connection" minOccurs=”0” maxOccurs="2" type="CT_Connection" />
        <xs:element name="PowerQueryConnection" minOccurs="0" maxOccurs="1" type="CT_PowerQueryConnection" />
        <xs:element name="PowerQueryMashupData" minOccurs="0" maxOccurs="1" type="xs:string" />
       </xs:sequence>
     </xs:complexType>
   </xs:element>
 </xs:schema>