Element 'return' was not found. Line 1, position 231 | System.Xml.XmlException | ReadStartElement

[Anonymous]

Hi,

I am using Power BI Desktop Version: 2.121.644.0 32-bit. I was testing to get data from SQL SERVER ANALYSIS SERVICE DATABASE before buying PowerBI license.

I got input request from PowerBI for DISCOVER_PROPERTIES.

And our server returns SOAP request to PowerBI, but it gives the following Error Message:
Element 'return' was not found. Line 1, position 231.

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.121.644.0","ModuleName":"Microsoft.PowerBI.AdomdClient.dll","Component":"Microsoft.AnalysisServices.AdomdClient.XmlaReader","Error":"System.Xml.XmlException","MethodDef":"ReadStartElement","ErrorOffset":"28","ErrorCode":""}

Stack Trace:
System.Xml.XmlException
at System.Xml.XmlReader.ReadStartElement(String name)

Here's the SOAP request that we're returning. Please tell me what response is expected by Power BI :

<SOAP-ENV:Envelope SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><SOAP-ENV:Body><m:DiscoverResponse xmlns:m="urn:schemas-microsoft-com:xml-analysis"><m:return xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><root xmlns="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:EX="urn:schemas-microsoft-com:xml-analysis:exception" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<xsd:schema elementFormDefault="qualified" targetNamespace="urn:schemas-microsoft-com:xml-analysis:rowset" xmlns:sql="urn:schemas-microsoft-com:xml-sql">
	<xsd:element name="root">
		<xsd:complexType>
			<xsd:sequence maxOccurs="unbounded" minOccurs="0">
				<xsd:element name="row" type="row"/>
			</xsd:sequence>
		</xsd:complexType>
	</xsd:element>
	<xsd:simpleType name="uuid">
		<xsd:restriction base="xsd:string">
			<xsd:pattern value="[0-9a-zA-Z]{8}-[0-9a-zA-Z]{4}-[0-9a-zA-Z]{4}-[0-9a-zA-Z]{4}-[0-9a-zA-Z]{12}"/>
		</xsd:restriction>
	</xsd:simpleType>
	<xsd:complexType name="xmlDocument">
		<xsd:sequence>
			<xsd:any/>
		</xsd:sequence>
	</xsd:complexType>
	<xsd:complexType name="row">
		<xsd:sequence>
			<xsd:element name="PropertyName" sql:field="PropertyName" type="xsd:string"/>
			<xsd:element minOccurs="0" name="PropertyDescription" sql:field="PropertyDescription" type="xsd:string"/>
			<xsd:element minOccurs="0" name="PropertyType" sql:field="PropertyType" type="xsd:string"/>
			<xsd:element name="PropertyAccessType" sql:field="PropertyAccessType" type="xsd:string"/>
			<xsd:element minOccurs="0" name="IsRequired" sql:field="IsRequired" type="xsd:boolean"/>
			<xsd:element minOccurs="0" name="Value" sql:field="Value" type="xsd:string"/>
		</xsd:sequence>
	</xsd:complexType>
</xsd:schema>
<row><PropertyName>Catalog</PropertyName><PropertyDescription>Catalog</PropertyDescription><PropertyType>string</PropertyType><PropertyAccessType>Read</PropertyAccessType><IsRequired>false</IsRequired><Value>D:\Sample_Model_Repository</Value></row><row><PropertyName>ServerName</PropertyName><PropertyDescription>ServerName</PropertyDescription><PropertyType>string</PropertyType><PropertyAccessType>Read</PropertyAccessType><IsRequired>false</IsRequired><Value>INBAWN167196.ad.com</Value></row><row><PropertyName>ProviderVersion</PropertyName><PropertyDescription>ProviderVersion</PropertyDescription><PropertyType>string</PropertyType><PropertyAccessType>Read</PropertyAccessType><IsRequired>false</IsRequired><Value>9.00.1399.06</Value></row><row><PropertyName>MdpropMdxSubqueries</PropertyName><PropertyDescription>MdpropMdxSubqueries</PropertyDescription><PropertyType>boolean</PropertyType><PropertyAccessType>Read</PropertyAccessType><IsRequired>false</IsRequired><Value>true</Value></row></root></m:return></m:DiscoverResponse></SOAP-ENV:Body></SOAP-ENV:Envelope>

Input Request from PowerBI:

<?xml version="1.0" encoding="UTF-8"?><Envelope xmlns="http://schemas.xmlsoap.org/soap/envelope/">
  <Header>
    <Version xmlns="http://schemas.microsoft.com/analysisservices/2003/engine/2" Sequence="922"/>
  </Header>
  <Body>
    <Discover xmlns="urn:schemas-microsoft-com:xml-analysis">
      <RequestType>DISCOVER_PROPERTIES</RequestType>
      <Restrictions/>
      <Properties>
        <PropertyList>
          <DbpropMsmdSubqueries>2</DbpropMsmdSubqueries>
          <LocaleIdentifier>16393</LocaleIdentifier>
        </PropertyList>
      </Properties>
    </Discover>
  </Body>
</Envelope>

[lbendlin]

Does your user have DISCOVER permissions against the cube?

[Anonymous]

@lbendlin , yes user have permission for DISCOVER. Infact, It's working for other data visualization tools other than powerBI.

Both are sending DISCOVER_PROPERTIES request.