Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I've used Power BI for several years, but am new to connecting Essbase to Power BI. I keep encountering this error message when trying to add a few different dimensions (same message with all dimensions). I've never encountered an error like this before and wanted to see if anyone has so that I can get it resolved. Thanks in advance for the assistance.
Regards,
Eric
Feedback Type:
Frown (Error)
Error Message:
The 'hr' start tag on line 1 position 235 does not match the end tag of 'BODY'. Line 1, position 241.
Stack Trace:
Microsoft.Mashup.Host.Document.SerializedException
Microsoft.Mashup.Evaluator.Interface.ErrorException: The 'hr' start tag on line 1 position 235 does not match the end tag of 'BODY'. Line 1, position 241. ---> System.Xml.XmlException: The 'hr' start tag on line 1 position 235 does not match the end tag of 'BODY'. Line 1, position 241. ---> System.Xml.XmlException: The 'hr' start tag on line 1 position 235 does not match the end tag of 'BODY'. Line 1, position 241.
at System.Xml.XmlTextReaderImpl.Throw(Exception e)
at System.Xml.XmlTextReaderImpl.ThrowTagMismatch(NodeData startTag)
at System.Xml.XmlTextReaderImpl.ParseEndElement()
at System.Xml.XmlTextReaderImpl.ParseElementContent()
at System.Xml.XmlReader.ReadToFollowing(String name)
at Microsoft.Mashup.Engine1.Library.Essbase.EssbaseXmlaParser.ParseResponseForError(XmlReader xmlReader, Func`3 ignoreErrorMessageFunction)
at Microsoft.Mashup.Engine1.Library.Essbase.EssbaseXmlaParser.ParseMdxResponse(TextReader reader, Dictionary`2 aliasDict)
at Microsoft.Mashup.Engine1.Library.Essbase.EssbaseService.ExecuteMdx(String sourceInfo, String application, String query, Dictionary`2 aliasDict)
at Microsoft.Mashup.Engine1.Library.Essbase.EssbaseCubeContextProvider.EssbaseCubeContext.GetDataReader(QueryCubeExpression expression)
at Microsoft.Mashup.Engine1.Library.Mdx.MdxCubeContext.ResultEnumerator.MoveNext()
at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.SerializeRows(Int32 count)
at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.ValuePreviewValueSource.TableValuePreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.<>c__DisplayClass0_0.<RunStub>b__0()
at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
--- End of inner exception stack trace ---
at Microsoft.Mashup.Evaluator.EvaluationHost.<>c__DisplayClass14_0.<TryReportException>b__1()
at Microsoft.Mashup.Common.SafeExceptions.IgnoreSafeExceptions(IEngineHost host, IHostTrace trace, Action action)
at Microsoft.Mashup.Evaluator.EvaluationHost.TryReportException(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Exception exception)
at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.RunStub(IEngineHost engineHost, IMessageChannel channel, Func`1 getPreviewValueSource)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.<>c__DisplayClass12_1`1.<OnBeginGetResult>b__0()
at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 action)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.EvaluationHost.Run()
at Microsoft.Mashup.Container.EvaluationContainerMain.Run(Object args)
at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass9_0.<CreateAction>b__0(Object o)
at Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args)
at Microsoft.Mashup.Container.EvaluationContainerMain.Main(String[] args)
--- End of inner exception stack trace ---
at Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_SmallValue()
at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)
Stack Trace Message:
The 'hr' start tag on line 1 position 235 does not match the end tag of 'BODY'. Line 1, position 241.
Invocation Stack Trace:
at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
at Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage)
at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e)
at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass14_0.<HandleException>b__0()
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Delegate.DynamicInvokeImpl(Object[] args)
at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClass4_1.<Main>b__2()
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at Microsoft.PowerBI.Client.Program.Main(String[] args)
PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.103.881.0","ModuleName":"","Component":"Microsoft.Mashup.Engine1.Library.Essbase.EssbaseXmlaParser","Error":"System.Xml.XmlException","MethodDef":"ParseResponseForError","ErrorOffset":""}
Snapshot Trace Logs:
C:\Users\ebrazis\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShote89e7c3c-cd02-4d83-abfb-fc8b41b8d58b.zip
Model Default Mode:
Import
Model Version:
PowerBI_V3
Performance Trace Logs:
C:\Users\ebrazis\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip
Enabled Preview Features:
PBI_enableWebView2
PBI_mobileAuthoringFormattingUI
PBI_useModernFormatPane
PBI_sparklines
Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_dataPointLassoSelect
PBI_compositeModelsOverAS
PBI_dynamicParameters
PBI_enhancedTooltips
PQ_WebView2Connector
PBI_scorecardVisual
PBI_lineChartError
Disabled DirectQuery Options:
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
PowerBINonFatalError_ErrorDescription:
Microsoft.Mashup.Host.Document.Evaluation.ErrorEvaluationResult
PowerBIUserFeedbackServices_IsReported:
True
Formulas:
section Section1;
shared #"NewLOB LOB" = let
Source = Essbase.Cubes("http://phtw146.pscu.root.test:19000/aps/XMLA", [CommandTimeout=#duration(0, 0, 30, 0)]),
phdw122 = Source{[Name="phdw122"]}[Data],
NewLOB = phdw122{[Name="NewLOB"]}[Data],
NewLOB.LOB = NewLOB{[Name="NewLOB.LOB"]}[Data],
#"Added Items" = Cube.Transform(NewLOB.LOB,
{
{Cube.AddMeasureColumn, "Revenue", "[Revenue]"}
}),
#"Added Items1" = Cube.Transform(#"Added Items",
{
{Cube.AddAndExpandDimensionColumn, "[Clients]", {"[Clients].Levels(1)"}, {"Clients.[Clients].Level 1"}}
}),
#"Added Items2" = Cube.Transform(#"Added Items1",
{
{Cube.AddAndExpandDimensionColumn, "[Company]", {"[Company].Levels(1)", "[Company].Levels(2)", "[Company].Levels(3)", "[Company].Levels(4)"}, {"Company.[Company].Level 1", "Company.[Company].Level 2", "Company.[Company].Level 3", "Company.[Company].Level 4"}}
}),
#"Added Items3" = Cube.Transform(#"Added Items2",
{
{Cube.AddAndExpandDimensionColumn, "[Group]", {"[Group].Levels(2)", "[Group].Levels(1)"}, {"Group.[Group].Level 2", "Group.[Group].Level 1"}}
}),
#"Added Items4" = Cube.Transform(#"Added Items3",
{
{Cube.AddAndExpandDimensionColumn, "[YR]", {"[YR].Levels(2)", "[YR].Levels(1)"}, {"YR.[YR].Level 2", "YR.[YR].Level 1"}}
}),
#"Added Items5" = Cube.Transform(#"Added Items4",
{
{Cube.AddAndExpandDimensionColumn, "[Scenario]", {"[Scenario].Levels(1)"}, {"Scenario.[Scenario].Level 1"}}
}),
#"Added Items6" = Cube.Transform(#"Added Items5",
{
{Cube.AddAndExpandDimensionColumn, "[Solutions]", {"[Solutions].Levels(1)", "[Solutions].Levels(2)", "[Solutions].Levels(3)"}, {"Solutions.[Solutions].Level 1", "Solutions.[Solutions].Level 2", "Solutions.[Solutions].Level 3"}}
})
in
#"Added Items6";
HI, @Anonymous,
This error message sounds like the request contents are invalid so the data connector cannot recognize these requests. (contents tag does not match)
I'd like to suggest you enter the query editor and change the navigation query step on your query table to confirm which steps show the error message.
Regards,
Xiaoxin Sheng
Hi @v-shex-msft ,
Thanks for providing feedback on the problem I'm running into. Would you be able to provide a screenshot of what you're referring to?
Regards,
Eric
Hiu @Anonymous,
In fact, I check the error message keywords and find it was an 'XML parsing' issue of 'end tag does not match the start tag'.
XML parsing: end tag does not match start tag - Stack Overflow
For this scenario, I'd like to suggest you check your query steps to confirm if this issue is caused by the data connector itself or the request parameter sent by yourself.
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |