cancel
Showing results for 
Search instead for 
Did you mean: 

Table Reports with Several Measures Error Out Power BI Desktop Live Connect to SSAS Tabular 2014

Hi
 
I am experencing an error when i try to add measures to a deep heirarchy on table  using a Power BI with a Live Conenction to ssas tabular.  The same report works very quickly using an Excel connected to the same SSAS Tabular Cube.  
 
The table report usese a heirarchy that is 6 Levels deep and results in 150-200 rows.  When i have a few measures it will run quicly. However once i add more than 3 or 4 measures the report  will crash resulting in the error message below.  I have tried the report using Power BI Desktop with a Live Connection to a Local instance of SSAS tabular and on PowerBI.com using a gateway to the same instance of SSAS Tabular.  
 
When i upload a smaller version of the model directly to Power BI the report works just fine.  For varisous reasons this does not neem to be an option at this point. Does anyone have any ideas why this would not work.
 
 
 
 
 
Feedback Type:
Frown (Error)
Error Message:
An error occurred while rendering the report.
Stack Trace:
TypeError: Cannot read property '10' of undefined
at TableExSelectionManager.getRowFromCell (ms-pbi://pbi.microsoft.com/minerva/scripts/pivotTableVisuals.js:5404:76)
at TableExSelectionManager.isDrillingEnabled (ms-pbi://pbi.microsoft.com/minerva/scripts/pivotTableVisuals.js:5349:65)
at TableEx.onBodyCellClick (ms-pbi://pbi.microsoft.com/minerva/scripts/pivotTableVisuals.js:5812:39)
at bodyCellClickHandler (ms-pbi://pbi.microsoft.com/minerva/scripts/pivotTableVisuals.js:5769:38)
at HTMLDivElement.<anonymous> (ms-pbi://pbi.microsoft.com/minerva/scripts/pivotTableVisuals.js:1834:37)
at ZoneDelegate.invokeTask (ms-pbi://pbi.microsoft.com/minerva/scripts/desktop.js:8343:189)
at Zone.runTask (ms-pbi://pbi.microsoft.com/minerva/scripts/desktop.js:8225:63)
at ZoneTask.invokeTask [as invoke] (ms-pbi://pbi.microsoft.com/minerva/scripts/desktop.js:8383:63)
at invokeTask (ms-pbi://pbi.microsoft.com/minerva/scripts/desktop.js:8929:68)
at HTMLDivElement.globalZoneAwareCallback (ms-pbi://pbi.microsoft.com/minerva/scripts/desktop.js:8939:60)
Stack Trace Message:
An error occurred while rendering the report.
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__DisplayClass1.<HandleException>b__0()
at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass3.<SendAndMarshalExceptions>b__0(Object null)
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.WebDialogs.WebDialog.<>n__FabricatedMethod8(IWindowHandle )
at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClass10.<Main>b__0()
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass7.<HandleExceptionsWithNestedTasks>b__6()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at Microsoft.PowerBI.Client.Program.Main(String[] args)

JS Error Message:
Uncaught TypeError: Cannot read property '10' of undefined
AS Live Connection:
True
Performance Trace Logs:
C:\Users\tucker\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip
Disabled Preview Features:
PBI_shapeMapVisualEnabled
MIntellisense
PBI_SpanishLinguisticsEnabled
PBI_PdfImport
PBI_ColumnProfiling
PBI_variationUIChange
PBI_PythonSupportEnabled
PBI_showIncrementalRefreshPolicy
PBI_showManageAggregations
PBI_FuzzyMatching
PBI_EnableWebDiagramView
PBI_improvedFilterExperience
Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
Recent Actions:
RemoveField, AddVisualContainer, VisualContainerPersistProperties, AddFieldToVisual, AddFieldToVisual, AddFieldToVisual, AddFieldToVisual, AddFieldToVisual, AddFieldToVisual, AddFieldToVisual, RemoveProjection, RemoveProjection, VisualContainerPersistProperties, VisualContainerPersistProperties, VisualContainerPersistProperties
Formulas:

section Section1;
Active Section Contract:
{"id":0,"name":"ReportSection","displayName":"Page 1","filters":"[{\"name\":\"Filter\",\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Dates\"}},\"Property\":\"Current Day\"}},\"filter\":{\"Version\":2,\"From\":[{\"Name\":\"d\",\"Entity\":\"Dates\"}],\"Where\":[{\"Condition\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"d\"}},\"Property\":\"Current Day\"}}],\"Values\":[[{\"Literal\":{\"Value\":\"'Current'\"}}]]}}}]},\"type\":\"Categorical\",\"howCreated\":1}]","ordinal":0,"visualContainers":[{"x":10,"y":0,"z":1,"width":280,"height":280,"config":"{\"name\":\"6c4f45e950167676589f\",\"layouts\":[{\"id\":0,\"position\":{\"x\":10,\"y\":0,\"width\":280,\"height\":280,\"z\":1}}],\"singleVisual\":{\"visualType\":\"slicer\",\"projections\":{\"Values\":[{\"queryRef\":\"Entity Dim.Composite Hierarchy.Entity_name\"}]},\"prototypeQuery\":{\"Version\":2,\"From\":[{\"Name\":\"e\",\"Entity\":\"Entity Dim\"}],\"Select\":[{\"HierarchyLevel\":{\"Expression\":{\"Hierarchy\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e\"}},\"Hierarchy\":\"Composite Hierarchy\"}},\"Level\":\"Entity_name\"},\"Name\":\"Entity Dim.Composite Hierarchy.Entity_name\"}]},\"drillFilterOtherVisuals\":true,\"objects\":{\"data\":[{\"properties\":{\"mode\":{\"expr\":{\"Literal\":{\"Value\":\"'Basic'\"}}}}}],\"general\":[{\"properties\":{\"filter\":{\"filter\":{\"Version\":2,\"From\":[{\"Name\":\"e\",\"Entity\":\"Entity Dim\"}],\"Where\":[{\"Condition\":{\"In\":{\"Expressions\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e\"}},\"Property\":\"Entity_name\"}}],\"Values\":[[{\"Literal\":{\"Value\":\"'1882 LLC'\"}}]]}}}]}}}}]},\"cachedFilterDisplayItems\":[{\"id\":{\"scopeId\":{\"Comparison\":{\"ComparisonKind\":0,\"Left\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"Entity Dim\"}},\"Property\":\"Entity_name\"}},\"Right\":{\"Literal\":{\"Value\":\"'1882 LLC'\"}}}}},\"displayName\":\"1882 LLC\"}]}}","filters":"[]"},{"x":10.33492822966507,"y":290.2392344497607,"z":2,"width":1250.5263157894735,"height":428.89952153110045,"config":"{\"name\":\"0d02d28c63d40c81d256\",\"layouts\":[{\"id\":0,\"position\":{\"x\":10.33492822966507,\"y\":290.2392344497607,\"z\":2,\"width\":1250.5263157894735,\"height\":428.89952153110045}}],\"singleVisual\":{\"visualType\":\"tableEx\",\"projections\":{\"Values\":[{\"queryRef\":\"Security Dim.IRM Tier1 -5 to Cusip.ind_level_2_cd\"},{\"queryRef\":\"Security Dim.IRM Tier1 -5 to Cusip.ind_level_3_cd\"},{\"queryRef\":\"Security Dim.IRM Tier1 -5 to Cusip.ind_level_4_cd\"},{\"queryRef\":\"Security Dim.IRM Tier1 -5 to Cusip.Ticker\"},{\"queryRef\":\"Security Dim.IRM Tier1 -5 to Cusip.sec_name\"},{\"queryRef\":\"Security Dim.IRM Tier1 -5 to Cusip.Cusip\"},{\"queryRef\":\"Characteristics.Market Value Plus AI\"},{\"queryRef\":\"Characteristics.OASD Weighted\"},{\"queryRef\":\"Characteristics.OASD Ctr\"},{\"queryRef\":\"Characteristics.OAD Weighted\"},{\"queryRef\":\"Characteristics.OAD Ctr\"},{\"queryRef\":\"Characteristics.Yield Weighted\"}]},\"prototypeQuery\":{\"Version\":2,\"From\":[{\"Name\":\"s\",\"Entity\":\"Security Dim\"},{\"Name\":\"c\",\"Entity\":\"Characteristics\"}],\"Select\":[{\"HierarchyLevel\":{\"Expression\":{\"Hierarchy\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Hierarchy\":\"IRM Tier1 -5 to Cusip\"}},\"Level\":\"ind_level_2_cd\"},\"Name\":\"Security Dim.IRM Tier1 -5 to Cusip.ind_level_2_cd\"},{\"HierarchyLevel\":{\"Expression\":{\"Hierarchy\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Hierarchy\":\"IRM Tier1 -5 to Cusip\"}},\"Level\":\"ind_level_3_cd\"},\"Name\":\"Security Dim.IRM Tier1 -5 to Cusip.ind_level_3_cd\"},{\"HierarchyLevel\":{\"Expression\":{\"Hierarchy\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Hierarchy\":\"IRM Tier1 -5 to Cusip\"}},\"Level\":\"ind_level_4_cd\"},\"Name\":\"Security Dim.IRM Tier1 -5 to Cusip.ind_level_4_cd\"},{\"HierarchyLevel\":{\"Expression\":{\"Hierarchy\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Hierarchy\":\"IRM Tier1 -5 to Cusip\"}},\"Level\":\"Ticker\"},\"Name\":\"Security Dim.IRM Tier1 -5 to Cusip.Ticker\"},{\"HierarchyLevel\":{\"Expression\":{\"Hierarchy\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Hierarchy\":\"IRM Tier1 -5 to Cusip\"}},\"Level\":\"sec_name\"},\"Name\":\"Security Dim.IRM Tier1 -5 to Cusip.sec_name\"},{\"HierarchyLevel\":{\"Expression\":{\"Hierarchy\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Hierarchy\":\"IRM Tier1 -5 to Cusip\"}},\"Level\":\"Cusip\"},\"Name\":\"Security Dim.IRM Tier1 -5 to Cusip.Cusip\"},{\"Measure\":{\"Expression\":{\"SourceRef\":{\"Source\":\"c\"}},\"Property\":\"Market Value Plus AI\"},\"Name\":\"Characteristics.Market Value Plus AI\"},{\"Measure\":{\"Expression\":{\"SourceRef\":{\"Source\":\"c\"}},\"Property\":\"OASD Weighted\"},\"Name\":\"Characteristics.OASD Weighted\"},{\"Measure\":{\"Expression\":{\"SourceRef\":{\"Source\":\"c\"}},\"Property\":\"OASD Ctr\"},\"Name\":\"Characteristics.OASD Ctr\"},{\"Measure\":{\"Expression\":{\"SourceRef\":{\"Source\":\"c\"}},\"Property\":\"OAD Weighted\"},\"Name\":\"Characteristics.OAD Weighted\"},{\"Measure\":{\"Expression\":{\"SourceRef\":{\"Source\":\"c\"}},\"Property\":\"OAD Ctr\"},\"Name\":\"Characteristics.OAD Ctr\"},{\"Measure\":{\"Expression\":{\"SourceRef\":{\"Source\":\"c\"}},\"Property\":\"Yield Weighted\"},\"Name\":\"Characteristics.Yield Weighted\"}],\"OrderBy\":[{\"Direction\":1,\"Expression\":{\"HierarchyLevel\":{\"Expression\":{\"Hierarchy\":{\"Expression\":{\"SourceRef\":{\"Source\":\"s\"}},\"Hierarchy\":\"IRM Tier1 -5 to Cusip\"}},\"Level\":\"Cusip\"}}}]},\"drillFilterOtherVisuals\":true}}","filters":"[]"},{"x":290,"y":0,"z":3,"width":971,"height":280,"config":"{\"name\":\"18b62b56d279962da322\",\"layouts\":[{\"id\":0,\"position\":{\"x\":290,\"y\":0,\"width\":971,\"height\":280,\"z\":3}}],\"singleVisual\":{\"visualType\":\"tableEx\",\"projections\":{\"Values\":[{\"queryRef\":\"Entity Dim.Entity_name\"}]},\"prototypeQuery\":{\"Version\":2,\"From\":[{\"Name\":\"e\",\"Entity\":\"Entity Dim\"}],\"Select\":[{\"Column\":{\"Expression\":{\"SourceRef\":{\"Source\":\"e\"}},\"Property\":\"Entity_name\"},\"Name\":\"Entity Dim.Entity_name\"}]},\"drillFilterOtherVisuals\":true}}","filters":"[]"}],"displayOption":1,"width":1280,"height":720,"config":"{}"}

Status: New
Comments
Moderator

Hi @T-Rock,

 

It looks like the issue only happens in Power BI desktop instead of Power BI service, right? 

 

Please update the Power BI desktop to the latest version and use 64 bit if possible. 

 

If issue still occurs, is it possible to share .abf file of this tabular database? If it is, you can upload it to your OneDrive and send the share link to me via private message. 

 

Best Regards,
Qiuyun Yu