- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content

Element 'return' was not found. Line 1, position 231 | System.Xml.XmlException | ReadStartElement
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>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- joakims on: "The import PowerPlatform.Dataflows matches no exp...
-
NikNithiy
on: URGENT!! Paginated Report not loading on Mozilla F...
- duarte on: Unable to sort months in PowerBI
-
mattlee on: “Add Value” in Textbox Not Visible in Dark Theme
- mattin on: Report Server Permissions Jan/May 2025
-
bhalicki
on: Bi Crashes on launch with (AS Process PID=XXXXXX H...
- stanteitelbaum on: authenticator wont trigger after purchase of new p...
-
Stinkys
on: Fix the Date function in DAX
-
Stinkys
on: Cannot login to community site
-
reubwork
on: May 25 update for Snowflake Connector v2 has broke...
- New 8,026
- Needs Info 3,502
- Investigating 3,602
- Accepted 2,088
- Declined 38
- Delivered 3,970
-
Reports
10,232 -
Data Modeling
4,131 -
Dashboards
4,114 -
Report Server
2,114 -
Gateways
2,112 -
APIS and Embedding
1,965 -
Custom Visuals
1,789 -
Content Packs
523 -
Mobile
354 -
Need Help
11 -
Show and Tell
3 -
General Comment
2 -
Tips and Tricks
1 -
Power BI Desktop
1