Power BI Crashes When Using Quick Measure

SReilly · ‎05-14-2024

After I select a particular Quick Measure and then the app freeze. Shortly after it populates an error message and no matter what I do the error message keeps coming back. So I have to completely shut down Power BI from the task manager and reboot.

Feedback Type: Frown (Error) Error Message:
An error occurred while rendering the report.

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__DisplayClass14_0.<HandleException>b__0()
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
at Microsoft.PowerBI.Client.PowerBIUnexpectedExceptionHandler.HandleException(Exception e)
at Microsoft.PowerBI.Client.Windows.Utilities.PowerBIFormUnexpectedExceptionHandler.HandleException(Exception e)
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.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.<>c__DisplayClass15_0.<ExecuteInteropCsMethod>b__0()
at Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.<ExecuteInteropCsMethod>d__15.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.ExecuteInteropCsMethod(Object interopObj, MethodInfo method, Object[] arguments, Nullable`1 runOn, Nullable`1 jsonOptions)
at Microsoft.PowerBI.Client.Windows.WebView2.WebView2Interop.<>c__DisplayClass22_0.<<InvokeCsMethod>b__0>d.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.Client.Windows.WebView2.WebView2Interop.<>c__DisplayClass22_0.<InvokeCsMethod>b__0()
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.HandleAwaitableAsyncExceptions(IExceptionHandler exceptionHandler, Func`1 asyncFunc)
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAsyncExceptions>d__0.MoveNext()
at System.Runtime.CompilerServices.AsyncVoidMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.HandleAsyncExceptions(IExceptionHandler exceptionHandler, Func`1 asyncFunc)
at Microsoft.PowerBI.Client.Windows.WebView2.WebView2Interop.InvokeCs(InteropCall call)
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at System.EventHandler`1.Invoke(Object sender, TEventArgs e)
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__DisplayClass7_0.<RunApplicationLegacy>b__0()
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.RunApplicationLegacy(String[] args)
at Microsoft.PowerBI.Client.Program.Main(String[] args)

JS Error Message:
Cannot read properties of undefined (reading 'value')

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.128.1380.0","ModuleName":"https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.quick-measures-lazy.min.js","Component":"","Error":"TypeError","MethodDef":"convertParameterToInputValue","ErrorOffset":"2128:53","ErrorCode":""}

Snapshot Trace Logs:
C:\Users\seanr\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot77595230-1448-4f1d-b8ef-3a5bd9ba1e94.zip

Model Default Mode:
Import

Model Version:
PowerBI_V3

Performance Trace Logs:
C:\Users\seanr\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Enabled Preview Features:
PBI_sparklines
PBI_scorecardVisual
PBI_NlToDax
PBI_fieldParametersSuperSwitch
PBI_angularRls
PBI_backstageUI
PBI_setLabelOnExportPdf
PBI_dynamicFormatString
PBI_oneDriveSave
PBI_oneDriveShare
PBI_gitIntegration
PBI_newCard
PBI_buttonSlicerAuthoring
PBI_mobileAutoReportLayout
PBI_daxQueryView
PBI_daxInlineCopilot
PBI_aiNarrativesVisual
PBI_generateMeasureDescriptionsButton
PBI_desktopReportAuthoringCopilot

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PBI_onObject
PBI_useModernPublishDialogs
PBI_tmdlInDataset
PBI_EimLessElevatedUser
PBI_modelExplorer
PBI_qnaImproveLsdlCopilot
PBI_visualCalculationsAuthoring

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

Recent Actions:
SaveFormattingValues, SaveFormattingValues, SaveFormattingValues, SaveFormattingValues, SaveFormattingValues, VisualContainerUpdateDimensions, VisualContainerUpdateDimensions, RenameNavigationTab, RenameNavigationTab, AddEmptyVisualContainer, VisualConversion, AddFieldInRole, AddFieldInRole, SetAggregate, CanvasKeyDelete

PowerBIUserFeedbackServices_IsReported:
True

Formulas:

section Section1;

shared #"Metric Trend" = let
Source = Excel.Workbook(File.Contents("C:\Users\seanr\Downloads\Shamrock @ DG Sales Trend Report - FY2024 Week 13.xlsm"), null, true),
#"Metric Trend_Sheet" = Source{[Item="Metric Trend",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(#"Metric Trend_Sheet", [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Item", Int64.Type}, {"Period", type text}, {"AvgSales$", type number}, {"AvgSalesUnits", type number}, {"TotalSales$", type number}, {"TotalSalesUnits", Int64.Type}, {"Stores Selling", type number}, {"Traited Stores", type number}, {"Instock Rate", type number}, {"Segment", type text}, {"Item Desc", type text}, {"Sub-Segment", type text}, {"Column13", type any}, {"Column14", type text}, {"Column15", type any}, {"Column16", type any}, {"Column17", type any}, {"Column18", type any}, {"Column19", type any}, {"Column20", type any}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Column13", "Column14", "Column15", "Column16", "Column17", "Column18", "Column19", "Column20"})
in
#"Removed Columns";

shared Table = let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8jE1UtJRMlSK1QGyjcyAbCMI29AYyDaGsC2ATBMI0wTINIWqADLNlGJjAQ==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Period = _t, Column2 = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Period", type text}, {"Column2", Int64.Type}})
in
#"Changed Type";

Active Section Contract:
{"name":"ReportSectionf032670c75c56590187b","displayName":"Sales By Segment","filters":"[]","ordinal":1,"visualContainers":[{"x":6.808510638297872,"y":73.9209726443769,"z":0,"width":860.790273556231,"height":218.8449848024316,"config":{"name":"383b49e36de848e4dece","layouts":[{"id":0,"position":

Anonymous · ‎05-15-2024

Having the exact same issue. Any solutions?

v-xiaoyan-msft · ‎05-15-2024

Hi @SReilly ,

We have seen on the internal platform that other engineers have reported this issue and submitted it.
The engineers on the product team are now aware and the fix will be deployed in the next release of Power BI Desktop.

Thanks for your patience！

Best regards.
Community Support Team_Caitlyn

gotters · ‎05-21-2024

I get a slightly different issue on measures - simply clicking on the 3 dots next to one of the measures I created also causes an error in PBI Desktop and I can no longer access any of my measures.

Is this a related problem and will it also be fixed in the next release? (which is when?)

Feedback Type:
Frown (Error)

Error Message:
An error occurred while rendering the report.

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__DisplayClass14_0.<HandleException>b__0()
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
at Microsoft.PowerBI.Client.PowerBIUnexpectedExceptionHandler.HandleException(Exception e)
at Microsoft.PowerBI.Client.Windows.Utilities.PowerBIFormUnexpectedExceptionHandler.HandleException(Exception e)
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.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.<>c__DisplayClass15_0.<ExecuteInteropCsMethod>b__0()
at Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.<ExecuteInteropCsMethod>d__15.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.ExecuteInteropCsMethod(Object interopObj, MethodInfo method, Object[] arguments, Nullable`1 runOn, Nullable`1 jsonOptions)
at Microsoft.PowerBI.Client.Windows.WebView2.WebView2Interop.<>c__DisplayClass22_0.<<InvokeCsMethod>b__0>d.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.Client.Windows.WebView2.WebView2Interop.<>c__DisplayClass22_0.<InvokeCsMethod>b__0()
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext()
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.HandleAwaitableAsyncExceptions(IExceptionHandler exceptionHandler, Func`1 asyncFunc)
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAsyncExceptions>d__0.MoveNext()
at System.Runtime.CompilerServices.AsyncVoidMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.HandleAsyncExceptions(IExceptionHandler exceptionHandler, Func`1 asyncFunc)
at Microsoft.PowerBI.Client.Windows.WebView2.WebView2Interop.InvokeCs(InteropCall call)
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at System.EventHandler`1.Invoke(Object sender, TEventArgs e)
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__DisplayClass7_0.<RunApplicationLegacy>b__0()
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.RunApplicationLegacy(String[] args)
at Microsoft.PowerBI.Client.Program.Main(String[] args)

JS Error Message:
Cannot read properties of undefined (reading 'capabilities')

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.129.905.0","ModuleName":"https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js","Component":"","Error":"TypeError","MethodDef":"canRename","ErrorOffset":"462917:43","ErrorCode":""}

AS Live Connection:
True

Performance Trace Logs:
C:\Users\User\Microsoft\Power BI Desktop Store App\PerformanceTraces.zip

Enabled Preview Features:
PBI_scorecardVisual
PBI_NlToDax
PBI_fieldParametersSuperSwitch
PBI_angularRls
PBI_backstageUI
PBI_dynamicFormatString
PBI_oneDriveSave
PBI_oneDriveShare
PBI_useModernPublishDialogs
PBI_publishDialogsSupportSubfolders
PBI_gitIntegration
PBI_newCard
PBI_buttonSlicerAuthoring
PBI_EimLessElevatedUser
PBI_mobileAutoReportLayout
PBI_daxInlineCopilot
PBI_aiNarrativesVisual
PBI_generateMeasureDescriptionsButton
PBI_desktopReportAuthoringCopilot

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PBI_sparklines
PBI_onObject
PBI_setLabelOnExportPdf
PBI_tmdlInDataset
PBI_qnaImproveLsdlCopilot
PBI_visualCalculationsAuthoring

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

Recent Actions:
AddEmptyVisualContainer, VisualContainerUpdateDimensions, VisualContainerUpdateDimensions, AddEmptyVisualContainer, VisualContainerUpdateDimensions

PowerBIUserFeedbackServices_IsReported:
True

Formulas:

section Section1;

Active Section Contract:
{"id":70729286,"name":"ReportSection238f06447e0526b0b822","displayName":"Geo Diversification","filters":"[{\"name\":\"Filtere8ff622b9e1675cb4087\",\"expression\":{\"Column\":{\"Expression\":{\"SourceRef\":{\"Entity\":\"MRI Dates\"}},\"Property\":\"Date\"}},\"filter\":{\"Version\":2,\"From\":[{\"Name\":\"m\",\"Entity\":\"MRI Dates\",\"Type\":0}],\"Where\":[{\"Condition\":{\"Comparison\":....
(full error too long to paste here)

gotters · ‎05-21-2024

Turns out my issue was a duplicate measure name! Would be nice if MS could at least prevent the duplicate measure name or give a usable error message instead of crashing PBI Desktop.

Solution is to double click and rename the measure and everything starts working again!

SReilly · ‎06-03-2024

Any resolution yet? Still having the issue

gotters · ‎06-04-2024

See above... my issue was duplicate measure names

Power BI Crashes When Using Quick Measure

disable option 'Synapse Data warehouse' in Power B...

Couldn't publish to Power BI

New slicers doesn't exist in power bi service

Why the hidden pages are not hidden for the export...

A Typo for save status of Power BI Desktop file on...