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

[hammohdahmed]

after install new version but still the problem available

Feedback Type:
Frown (Error)

Timestamp:
2023-03-30T10:33:33.8004199Z

Local Time:
2023-03-30T13:33:33.8004199+03:00

Session ID:
bc3efdb1-0fb0-45b6-b1f9-020cddee536c

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.1 GB

Private Memory:
656 MB

Peak Working Set:
867 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\FrownSnapShotd7f90897-fb4c-46ce-aff0-077a4519ed5d.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";

[TeresaBulcroft]

I am having this same issue. Does anyone know where I can get an older version of the 32 bit download?

[eb5915]

@TeresaBulcroft

You can find the older versions here:

Previous monthly updates to Power BI Desktop and the Power BI service - Power BI | Microsoft Learn

There are download links for both 64-bit and 32-bit versions at the bottom of the "February 2023 Update (2.114.664.0)" section.

[TeresaBulcroft]

Thank you so much @eb5915! that worked. I really appreciate it!

Teresa

[jsemtoja]

Still not working. Same issue on Product Version: 2.115.842.0

[eb5915]

There is a new version of Power BI Desktop available for download...version 2.115.1006.0 published 4/4/2023.

Unfortunately, this version did not fix the issue.

[eb5915]

@v-xiaoyan-msft -

Any update from the MS engineering team on this issue?

[JessieF]

Just wanted to comment that we have two users in our org reporting this exact issue. We have dozens of Power BI users but only 2 are reporting the issue. Both have had latest version re-installed multiple times. One user is experiencing this intermittently and one is experiencing it every time they open Desktop.

[TeresaBulcroft]

@JessieF Going back to the Feb 23 version worked for me. Thank you!

[eb5915]

@v-xiaoyan-msft -

Any update from the MS engineering team on this issue?