Power BI Desktop crash - March 2023 Release version 2.115.663.0 (x86)

[Saad_ghraybeh]

Hallow everyone,

after updating Power BI desktop from version 2.114 (Feb 2023 Release) to the March 2023 version, the app crashed immediately on startup giving an error that an external component has thrown an exception. the application is installed on a windows server 2012 R2, some error details are below.

I thought I would roll back to Dec. 2022 version to see if it works, I unfortunatlly don't have the 2.114 setup file anymore.

Please help.

Feedback Type:
Frown (Error)

Timestamp:
2023-03-15T08:47:28.9016104Z

Local Time:
2023-03-15T11:47:28.9016104+03:00

Session ID:
7cfb7f39-7cf7-44db-8be6-d6e192c4b1e2

Release:
March 2023

Product Version:
2.115.663.0 (x86)

Stack Trace:
System.Runtime.InteropServices.SEHException
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.Application.RunDialog(Form form)
at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
at Microsoft.Mashup.Client.UI.Windows.DialogWindowBase.ShowModal(IWindowHandle windowHandle)
at Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>n__0(IWindowHandle owner)
at Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>c__DisplayClass57_0.<ShowModal>b__0()
at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
at Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.ShowModal(IWindowHandle owner)
at Microsoft.Mashup.Client.UI.Shared.Ux.WindowService.ShowDialog(IDialog dialog)
at Microsoft.PowerBI.Client.Windows.FloatingDialog.StartDialog.Show(IPowerBIWindowService windowService, IExceptionHandler exceptionHandler, IPowerBIQueryUIService queryServices, IReportManager reportManager, IAutoRecoveryManager autoRecoveryManager, ILegacyUIHost uiHost, IUIBlockingService uiBlockingService, IPowerBIWindowServiceFactory windowServiceFactory, IFileHistoryManager fileHistoryManager, IAuthenticationManager authenticationManager, IUpdateNotificationManager updateNotificationManager, IApplicationCommands applicationCommands, IPowerBISettings powerBISettings, IUISettings uiSettings, IEventAggregationService eventAggregationService, IPowerBITelemetryService telemetryService, IUrlOpener urlOpener)
at Microsoft.PowerBI.Client.Windows.MainWindow.<ShowStartDialog>d__96.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd(Task task)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClass5_3.<<RunApplication>b__12>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Windows.MainWindow.<<ActivateMainWindow>b__116_1>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext()

Error Code:
-2147467259 (0x80004005)

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.115.663.0","ModuleName":"Microsoft.Mashup.Client.UI.dll","Component":"Microsoft.Mashup.Client.UI.Windows.DialogWindowBase","Error":"System.Runtime.InteropServices.SEHException","MethodDef":"ShowModal","ErrorOffset":"17"}

OS Version:
Microsoft Windows NT 6.3.9600.0 (x64 en-US)

CLR Version:
4.8 or later [Release Number = 528049]

Peak Virtual Memory:
1.58 GB

Private Memory:
519 MB

Peak Working Set:
687 MB

IE Version:
11.0.9600.20874

User ID:
4259c6c6-f912-426e-8a86-b621577bd7f5

Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: False.

Telemetry Enabled:
True

Model Default Mode:
Empty

Model Version:
PowerBI_V1

Enabled Preview Features:
PBI_enableWebView2
PQ_WebView2Connector
PBI_sparklines
PBI_scorecardVisual
PBI_fieldParametersSuperSwitch
PBI_horizontalFusion
PBI_relationshipEditPane
PBI_setLabelOnExportPdf

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_compositeModelsOverAS
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PBI_NlToDax
PBI_optimizeTabRibbon
PBI_angularRls
PBI_onObject

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

[jsemtoja]

We are facing same issue on same version. 

[jayleenz]

We are having the same issue so I had to roll back to Feb 2023 version.

What is going on and why this error occuring?

[isaez]

Same issue here, as a remark, i am able to open files which have exclusively a DirectQuery data source. All other models, import and hybrid, crash.

I will try to roll back to February version, but i cant imagine that is the long term strategy? are there already any hints as to why this is happening, other than its the March 17 version?

[hammohdahmed]

Feedback Type:
Frown (Error)

Timestamp:
2023-03-27T10:49:10.4032656Z

Local Time:
2023-03-27T13:49:10.4032656+03:00

Session ID:
d4988cee-52ad-4db4-8ed2-af3ce1fa80cf

Release:
March 2023

Product Version:
2.115.842.0 (x64)

Error Message:
Failed to load the report.

Stack Trace:
TypeError: Cannot read properties of undefined (reading 'properties')
at VersionUpgrader.upgradeVisualObjects (https://ms-pbi.pbi.microsoft.com/minerva/scripts/explore.js:24993:60)
at VisualObjectsUpgrader.upgrade (https://ms-pbi.pbi.microsoft.com/minerva/scripts/explore.js:25083:78)
at ExplorationUpgrader.upgradeVisualObjects (https://ms-pbi.pbi.microsoft.com/minerva/scripts/explore.js:16646:85)
at ExplorationUpgrader.upgrade (https://ms-pbi.pbi.microsoft.com/minerva/scripts/explore.js:16614:51)
at ExplorationSerializer.deserializeExploration (https://ms-pbi.pbi.microsoft.com/minerva/scripts/explore.js:15254:55)
at ExplorationSerializer.deserializeExploration (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:276889:41)
at DesktopExplorationProxyService.<anonymous> (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:214703:81)
at https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:90878:43
at Object.next (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:90889:26)
at fulfilled (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:90793:44)

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.ErrorHostService.GetErrorDetails(ShowErrorDialogArgs args)
at Microsoft.PowerBI.Client.Windows.ErrorHostService.<>c__DisplayClass5_0.<ShowErrorDialogCore>b__0()
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.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)
at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)
at System.Windows.Forms.WindowsFormsSynchronizationContext.Send(SendOrPostCallback d, Object state)
at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.AllowModalDialogs(Action action)
at Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.<>c__DisplayClass14_0.<ExecuteOnUIThreadAndHandlePromise>b__0()
at Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.ExecuteOnUIThreadAndHandlePromise[T](Func`1 func, IPromiseStore promiseStore, Int64 promiseHandle)
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.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__DisplayClass5_1.<RunApplication>b__4()
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.RunApplication(String[] args)
at Microsoft.PowerBI.Client.Program.Main(String[] args)

OS Version:
Microsoft Windows NT 10.0.19045.0 (x64 en-US)

CLR Version:
4.8 or later [Release Number = 528372]

Peak Virtual Memory:
70 GB

Private Memory:
504 MB

Peak Working Set:
717 MB

IE Version:
11.789.19041.0

User ID:
de8e9134-c248-4024-8a9c-31fe11122b95

Workbook Package Info:
1* - en-US, Query Groups: 1, fastCombine: Disabled, runBackgroundAnalysis: False.

Telemetry Enabled:
True

Snapshot Trace Logs:
C:\Users\hamza\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShotf5ffdc32-4d10-4310-bd10-f583b3ccc697.zip

Model Default Mode:
Import

Model Version:
PowerBI_V3

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

Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_compositeModelsOverAS
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PBI_enableWebView2
PQ_WebView2Connector
PBI_sparklines
PBI_scorecardVisual
PBI_NlToDax
PBI_fieldParametersSuperSwitch
PBI_horizontalFusion
PBI_optimizeTabRibbon
PBI_relationshipEditPane
PBI_angularRls
PBI_onObject
PBI_setLabelOnExportPdf

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

Formulas:

section Section1;

shared Tous_Stores_Lookup = let
Source = Sql.Databases("mybis"),
Tous = Source{[Name="Tous"]}[Data],
dbo_stores_master = Tous{[Schema="dbo",Item="stores_master"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(dbo_stores_master,{{"store_id", Int64.Type}}),
#"Filtered Rows" = Table.SelectRows(#"Changed Type", each true)
in
#"Filtered Rows";

shared Tous_Sales = let
Source = Sql.Databases("mybis"),
Tous = Source{[Name="Tous"]}[Data],
dbo_daily_sales = Tous{[Schema="dbo",Item="View_daily_salesAll"]}[Data],
#"Rounded Off" = Table.TransformColumns(dbo_daily_sales,{{"tax", each Number.Round(_, 2), type number}}),
#"Rounded Off1" = Table.TransformColumns(#"Rounded Off",{{"item_price", each Number.Round(_, 2), type number}}),
#"Rounded Off2" = Table.TransformColumns(#"Rounded Off1",{{"net_amount_withvat", each Number.Round(_, 2), type number}}),
#"Rounded Off3" = Table.TransformColumns(#"Rounded Off2",{{"net_amount", each Number.Round(_, 2), type number}}),
#"Rounded Off4" = Table.TransformColumns(#"Rounded Off3",{{"cost_price", each Number.Round(_, 2), type number}}),
#"Changed Type" = Table.TransformColumnTypes(#"Rounded Off4",{{"invoice_date", type date}}),
#"Added Conditional Column" = Table.AddColumn(#"Changed Type", "SalesType", each if [units] > 0 then "Sales" else if [units] < 0 then "Returns" else "Others"),
#"Filtered Rows" = Table.SelectRows(#"Added Conditional Column", each true),
#"Changed Type1" = Table.TransformColumnTypes(#"Filtered Rows",{{"units", type number}}),
#"Filtered Rows1" = Table.SelectRows(#"Changed Type1", each true),
#"Inserted Year" = Table.AddColumn(#"Filtered Rows1", "Year", each Date.Year([invoice_date]), Int64.Type),
#"Filtered Rows2" = Table.SelectRows(#"Inserted Year", each true)
in
#"Filtered Rows2";

shared Tous_Sales_Return = let
Source = Sql.Databases("mybis"),
Tous = Source{[Name="Tous"]}[Data],
dbo_View_Tous_Sales_Return = Tous{[Schema="dbo",Item="View_Tous_Sales_Return"]}[Data],
#"Rounded Off" = Table.TransformColumns(dbo_View_Tous_Sales_Return,{{"tax", each Number.Round(_, 2), type number}}),
#"Rounded Off1" = Table.TransformColumns(#"Rounded Off",{{"net_amount_withvat", each Number.Round(_, 2), type number}}),
#"Rounded Off2" = Table.TransformColumns(#"Rounded Off1",{{"net_amount", each Number.Round(_, 2), type number}}),
#"Rounded Off3" = Table.TransformColumns(#"Rounded Off2",{{"cost_price", each Number.Round(_, 2), type number}}),
#"Changed Type" = Table.TransformColumnTypes(#"Rounded Off3",{{"units", type number}}),
#"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"net_amount", "Return Net Amount"}})
in
#"Renamed Columns";

shared Tous_Products_Lookup = let
Source = Sql.Databases("mybis"),
Tous = Source{[Name="Tous"]}[Data],
dbo_View_Tous_Products_Master = Tous{[Schema="dbo",Item="View_Tous_Products_Master"]}[Data],
#"Added Conditional Column" = Table.AddColumn(dbo_View_Tous_Products_Master, "Category", each if [item_family] = "Bolsos" then 1 else if [item_family] = "Joyería" then 2 else if [item_family] = "Relojería" then 3 else if [item_family] = "Perfumeria" then 4 else if [item_family] = "Marroquinería" then 5 else if [item_family] = "Textil" then 6 else if [item_family] = "Otros" then 7 else if [item_family] = "Optica" then 8 else "9"),
#"Filtered Rows" = Table.SelectRows(#"Added Conditional Column", each true),
#"Changed Type" = Table.TransformColumnTypes(#"Filtered Rows",{{"Category", Int64.Type}}),
#"Filtered Rows1" = Table.SelectRows(#"Changed Type", each true),
#"Changed Type1" = Table.TransformColumnTypes(#"Filtered Rows1",{{"Category", Int64.Type}}),
#"Merged Queries" = Table.NestedJoin(#"Changed Type1", {"Category"}, Tous_Categories_Lookup, {"s_no"}, "Tous_Categories_Lookup", JoinKind.LeftOuter),
#"Expanded Tous_Categories_Lookup" = Table.ExpandTableColumn(#"Merged Queries", "Tous_Categories_Lookup", {"category_english"}, {"Tous_Categories_Lookup.category_english"}),
#"Duplicated Column" = Table.DuplicateColumn(#"Expanded Tous_Categories_Lookup", "item_code", "item_code - Copy"),
#"Removed Columns" = Table.RemoveColumns(#"Duplicated Column",{"item_code - Copy"}),
#"Removed Duplicates" = Table.Distinct(#"Removed Columns", {"item_code"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Duplicates",{{"Tous_Categories_Lookup.category_english", "Eng_Name"}})
in
#"Renamed Columns";

shared Tous_Categories_Lookup = let
Source = Sql.Databases("mybis"),
Tous = Source{[Name="Tous"]}[Data],
dbo_Categories_Mapping = Tous{[Schema="dbo",Item="Categories_Mapping"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(dbo_Categories_Mapping,{{"s_no", Int64.Type}})
in
#"Changed Type";

shared Rolling_Calendar_Lookup = let
Source = #date(2000,1,1),
Custom1 = List.Dates(Source, Number.From(DateTime.LocalNow()) -Number.From(Source),#duration(1,0,0,0)),
#"Converted to Table" = Table.FromList(Custom1, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Renamed Columns" = Table.RenameColumns(#"Converted to Table",{{"Column1", "Date"}}),
#"Added Index" = Table.AddIndexColumn(#"Renamed Columns", "Index", 1, 1, Int64.Type),
#"Reordered Columns" = Table.ReorderColumns(#"Added Index",{"Index", "Date"}),
#"Renamed Columns1" = Table.RenameColumns(#"Reordered Columns",{{"Index", "Time_id"}}),
#"Inserted Day" = Table.AddColumn(#"Renamed Columns1", "Day", each Date.Day([Date]), Int64.Type),
#"Inserted Day Name" = Table.AddColumn(#"Inserted Day", "Day Name", each Date.DayOfWeekName([Date]), type text),
#"Inserted Start of Week" = Table.AddColumn(#"Inserted Day Name", "Start of Week", each Date.StartOfWeek([Date]), type date),
#"Removed Columns" = Table.RemoveColumns(#"Inserted Start of Week",{"Start of Week"}),
#"Inserted Month" = Table.AddColumn(#"Removed Columns", "Month", each Date.Month([Date]), Int64.Type),
#"Inserted Month Name" = Table.AddColumn(#"Inserted Month", "Month Name", each Date.MonthName([Date]), type text),
#"Inserted Quarter" = Table.AddColumn(#"Inserted Month Name", "Quarter", each Date.QuarterOfYear([Date]), Int64.Type),
#"Inserted Year" = Table.AddColumn(#"Inserted Quarter", "Year", each Date.Year([Date]), Int64.Type),
#"Inserted Start of Week1" = Table.AddColumn(#"Inserted Year", "Start of Week", each Date.StartOfWeek([Date]), type date),
#"Inserted Start of Month" = Table.AddColumn(#"Inserted Start of Week1", "Start of Month", each Date.StartOfMonth([Date]), type date),
#"Inserted Start of Year" = Table.AddColumn(#"Inserted Start of Month", "Start of Year", each Date.StartOfYear([Date]), type date),
#"Changed Type" = Table.TransformColumnTypes(#"Inserted Start of Year",{{"Date", type date}})
in
#"Changed Type";

here is same!!!

[rbrocks]

This is an issue with all users at my company using the 32 bit version of Power BI Desktop updated for March 2023. I recommended that they switch t the 64 bit version and several have been able to with success. But many tickets coming in. So the 32 bit version is definitely broken. 

[eb5915]

We are experiencing the same issue with the 32-bit version of PBI desktop, although this is only impacting a subset of our PBI users. I've tried versions 2.115.663.0 and 2.115.842.0...both experience the crashing issue.

Switching to 64-bit version is not an option for us currently. As others have posted, the only fix was to downgrade impacted users to the Feb release (2.114.864.0).

[gaznez]

Happening at our organisation too (using the 32-bit version).  Application opens - but then crashes (and closes) before you can do anything.

[v-xiaoyan-msft]

Hi  all,

We have seen this issue submitted by engineers on our internal platform to the product team.

Problem: After installing Power BI Desktop "March 2023 Update (2.115.663.0) " version, there was a startup error "External Component has thrown an exception" 

They have been aware of the issue and the engineers will do their best to resolve it. I will update here if there is any progress, so please be patient. 

Best regards.
Community Support Team_ Caitlyn

[v-xiaoyan-msft]

Hi all,

Update:

Power BI released the latest version 2.115.842.0 64-bit (March 2023) , please download it to see if the problem still exists.

Download Microsoft Power BI Desktop from Official Microsoft Download Center

----------------------------------------------------------------------------------------------------------

We have seen this issue submitted by engineers on our internal platform to the product team.

Problem: After installing Power BI Desktop "March 2023 Update (2.115.663.0) " version, there was a startup error "External Component has thrown an exception" 

They have been aware of the issue and the engineers will do their best to resolve it. I will update here if there is any progress, so please be patient. 

Best regards.
Community Support Team_ Caitlyn

[gaznez]

I was getting the errors on version 2.115.842.0 32-bit (March 2023).  Is there a new 32-bit version?