Recurring Error - Cannot read properties of undefined (reading 'kind')
Hi, I have recurring error in Power BI desktop visualization. I am not able to do any changes. I am sending details below, can you please help?
Thank you in advance
F
Feedback Type:
Frown (Error)
Timestamp:
2023-10-25T11:48:42.3638421Z
Local Time:
2023-10-25T13:48:42.3638421+02:00
Session ID:
a6eaf755-c5a8-4b5b-ae06-616dd5c20264
Release:
October 2023
Product Version:
2.122.746.0 (23.10) (x64)
Stack Trace:
Javascript:TypeError
at SQExpr.isTransformOutputRoleRef (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:234567:33)
at FieldListConceptualModel.findItems (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:505985:121)
at FieldListReportAuthoringService.getModelItemsFromSelectedVisual (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:439486:394)
at FieldListReportAuthoringService.updateFieldListCheckFromSelectedVisual (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:439426:65)
at HTMLDivElement.<anonymous> (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:439420:71)
at HTMLDivElement.dispatch (https://ms-pbi.pbi.microsoft.com/minerva/scripts/jquery.js:5429:27)
at elemData.handle (https://ms-pbi.pbi.microsoft.com/minerva/scripts/jquery.js:5233:28)
at Object.trigger (https://ms-pbi.pbi.microsoft.com/minerva/scripts/jquery.js:8715:12)
at HTMLDivElement.<anonymous> (https://ms-pbi.pbi.microsoft.com/minerva/scripts/jquery.js:8793:17)
at Function.each (https://ms-pbi.pbi.microsoft.com/minerva/scripts/jquery.js:381:19)
PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.122.746.0","ModuleName":"https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js","Component":"SQExpr","Error":"TypeError","MethodDef":"isTransformOutputRoleRef","ErrorOffset":"234567:33","ErrorCode":""}
OS Version:
Microsoft Windows NT 10.0.22621.0 (x64 cs-CZ)
CLR Version:
4.8 or later [Release Number = 533320]
Peak Virtual Memory:
71.5 GB
Private Memory:
1.1 GB
Peak Working Set:
1.75 GB
IE Version:
11.1.22621.0
User ID:
2ada8574-5438-4054-8124-c53be43c8499
Workbook Package Info:
1* - cs-CZ, Query Groups: 0, fastCombine: Enabled, runBackgroundAnalysis: False.
Telemetry Enabled:
True
Model Default Mode:
Import
Model Version:
PowerBI_V3
Enabled Preview Features:
PBI_sparklines
PBI_scorecardVisual
PBI_NlToDax
PBI_fieldParametersSuperSwitch
PBI_setLabelOnExportPdf
PBI_dynamicFormatString
PBI_oneDriveSave
PBI_oneDriveShare
PBI_newCard
Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PBI_angularRls
PBI_onObject
PBI_backstageUI
PBI_gitIntegration
PBI_modelExplorer
Disabled DirectQuery Options:
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
DPI Scale:
100%
Supported Services:
Power BI
4 Comments
- AnonymousNot applicable
Hi NewPBI_user ,
Based on the information available, here are a few potential solutions you could try:
1.Enable the Fast Combine feature within Power Query by going into the Options => Project Options => Enable "Allow combining data from multiple datasources."
2.Remove the caret ^ symbol from the package i.e. “ng-multiselect-dropdown”: “^0.2.3” to “ng-multiselect-dropdown”: "0.2.3"
3.Check if the visual you are using was recently updated and recreate the report if needed.Best regards.
Community Support Team_Caitlyn - NewPBI_userFrequent Visitor
Hi Anonymous ,
Thank you for quick reply. Please see my comments below and I am sending new details.
Also I tried to do the same report in older version of my PBI file and happened the same. So I think the problem will be in the specific matrix and/or measures which I try to do. I have very complex data model.
1.Enable the Fast Combine feature within Power Query by going into the Options => Project Options => Enable "Allow combining data from multiple datasources." - I did but the problem is still the same
2.Remove the caret ^ symbol from the package i.e. “ng-multiselect-dropdown”: “^0.2.3” to “ng-multiselect-dropdown”: "0.2.3" - I do not have any caret ^ symbol - I did not find any caret symbol
3.Check if the visual you are using was recently updated and recreate the report if needed. - I am not able to do anything with the visuals right now, even not possible to delete sheet or anything. I only can delete measures so I deleted the once which were used for the matrix which is causing the problem probably. But nothing happened.Please see details below, I just deleted formulas to avoid sharing the source of data.
Feedback Type:
Frown (Error)
Error Message:
Při vykreslování sestavy došlo k chybě.
Stack Trace:
Javascript:TypeError
at SQExpr.isTransformOutputRoleRef (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:234567:33)
at FieldListConceptualModel.findItems (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:505985:121)
at FieldListReportAuthoringService.getModelItemsFromSelectedVisual (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:439486:394)
at FieldListReportAuthoringService.updateFieldListCheckFromSelectedVisual (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:439426:65)
at HTMLDivElement.<anonymous> (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:439420:71)
at HTMLDivElement.dispatch (https://ms-pbi.pbi.microsoft.com/minerva/scripts/jquery.js:5429:27)
at elemData.handle (https://ms-pbi.pbi.microsoft.com/minerva/scripts/jquery.js:5233:28)
at Object.trigger (https://ms-pbi.pbi.microsoft.com/minerva/scripts/jquery.js:8715:12)
at HTMLDivElement.<anonymous> (https://ms-pbi.pbi.microsoft.com/minerva/scripts/jquery.js:8793:17)
at Function.each (https://ms-pbi.pbi.microsoft.com/minerva/scripts/jquery.js:381:19)
Stack Trace Message:
Při vykreslování sestavy došlo k chybě.
Invocation Stack Trace:
v Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
v Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage)
v Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e)
v Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
v Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass14_0.<HandleException>b__0()
v Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
v Microsoft.PowerBI.Client.PowerBIUnexpectedExceptionHandler.HandleException(Exception e)
v Microsoft.PowerBI.Client.Windows.Utilities.PowerBIFormUnexpectedExceptionHandler.HandleException(Exception e)
v System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
v System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
v System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
v Microsoft.PowerBI.Client.Windows.WebView2.WebView2Interop.InvokeCs(InteropCall call)
v Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
v System.EventHandler`1.Invoke(Object sender, TEventArgs e)
v System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
v System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
v System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
v System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
v System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
v System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
v Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
v Microsoft.PowerBI.Client.Program.<>c__DisplayClass6_0.<RunApplication>b__0()
v Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()
v Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
v Microsoft.PowerBI.Client.Program.RunApplication(String[] args)
v Microsoft.PowerBI.Client.Program.Main(String[] args)
JS Error Message:
Cannot read properties of undefined (reading 'kind')
PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.122.746.0","ModuleName":"https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js","Component":"SQExpr","Error":"TypeError","MethodDef":"isTransformOutputRoleRef","ErrorOffset":"234567:33","ErrorCode":""}
Snapshot Trace Logs:
C:\Users\Office\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot7c697142-eca9-4c8a-86f7-fd8015f9359a.zip
Model Default Mode:
Import
Model Version:
PowerBI_V3
Performance Trace Logs:
C:\Users\Office\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip
Enabled Preview Features:
PBI_sparklines
PBI_scorecardVisual
PBI_NlToDax
PBI_fieldParametersSuperSwitch
PBI_setLabelOnExportPdf
PBI_dynamicFormatString
PBI_oneDriveSave
PBI_oneDriveShare
PBI_newCard
Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PBI_angularRls
PBI_onObject
PBI_backstageUI
PBI_gitIntegration
PBI_modelExplorer
Disabled DirectQuery Options:
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
PowerBIUserFeedbackServices_IsReported:
True
Thank you very much for your help
- AnonymousNot applicable
Hi NewPBI_user ,
Thank you for the information we will do further investigation and I will feed back here with any progress.
Best regards.
Community Support Team_ Caitlyn - TimoRiikonen
Advocate V
I got the same error. One of the connections failed to log in. Login had succeeded in the past, but it had expired (thankfully this happens practically never) or something.