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>
v-xiaoyan-msft
on:
Incorrect value shows in table, and duplicate row ...