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";
