Every time I attempt to create any Relationships between tables, I get the error message below. Any help would be greatly appreciated. Reinstalling the software is a last resort option.
Feedback Type:
Frown (Error)
Timestamp:
2025-10-17T19:45:57.4282358Z
Local Time:
2025-10-17T15:45:57.4282358-04:00
Session ID:
7c8f6bd0-fa7f-4675-9dbd-6b4844b65147
Release:
July 2025
Product Version:
2.145.1262.0 (25.07)+10bdeda5ab0db954b2cf824e7a117ad7cee97f88 (x64)
Error Message:
Object reference not set to an instance of an object.
Stack Trace:
Microsoft.Mashup.Host.Document.SerializedException
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.Mashup.OleDbProvider.DataHost.NonBufferingMashupEvaluator.MashupEvaluation.OnEvaluationComplete(AsyncResult`1 result)
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.Mashup.OleDbProvider.MashupCommandEvaluation.get_PageReader()
at Microsoft.Mashup.OleDbProvider.TracingRowset.Microsoft.OleDb.IEvaluationResultSource.WaitForResults()
Stack Trace Message:
Object reference not set to an instance of an object.
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.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass2_0.<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.Windows.DialogWindowBase.ShowModal(IWindowHandle windowHandle)
at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
at Microsoft.PowerBI.Client.Windows.FloatingDialog.MinervaDialog.Show(IWindowHandle owner, String dialogDefinitionJson, String urlAllowedForFrame, String urlAllowedForPopup)
at Microsoft.PowerBI.Client.Windows.Services.MinervaModalDialogManager.<>c__DisplayClass16_0.<ShowMinervaModalDialogInternal>b__0(IWindowHandle ownerWindow)
at Microsoft.PowerBI.Client.Windows.Services.PowerBIWindowServiceExtensions.<>c__DisplayClass0_0.<ExecuteWithLegacyOwnerWindow>b__0(IWindowHandle ownerWindow)
at Microsoft.PowerBI.Client.Windows.Services.MinervaModalDialogManager.ShowMinervaModalDialogInternal(MinervaDialog dialog, String dialogDefinitionJson, ILegacyUIHost uiHost, IExceptionHandler exceptionHandler, IPowerBIWindowService windowService, String urlAllowedForFrame, String urlAllowedForPopup, Action onCloseAction)
at Microsoft.PowerBI.Client.Windows.Services.MinervaModalDialogManager.ShowNestedMinervaModalDialog(String dialogDefinitionJson, ILegacyUIHost uiHost, IExceptionHandler exceptionHandler, IPowerBIWindowService windowService, String urlAllowedForFrame, String urlAllowedForPopup, Action onCloseAction, Task closeOnCompletionTask)
at Microsoft.PowerBI.Client.Windows.Services.MinervaModalDialogManager.ShowMinervaModalDialog(String dialogDefinitionJson, ILegacyUIHost uiHost, IExceptionHandler exceptionHandler, IPowerBIWindowService windowService, String urlAllowedForFrame, String urlAllowedForPopup, Action onCloseAction)
at Microsoft.PowerBI.Client.Windows.ModalDialogHostService.<>c__DisplayClass9_0.<ShowHostModalDialog>b__1()
at Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.<>c__DisplayClass4_0`1.<ExecuteOnUIThread>b__0()
at Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.<>c__DisplayClass3_0.<ExecuteOnUIThread>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.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.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
at Microsoft.PowerBI.Client.AppModule.<>c__DisplayClass4_0.<Run>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.AppModule.Run()
at Microsoft.PowerBI.Client.Program.RunApplicationFlow(String[] args, IPowerBIRootTrace trace)
at Microsoft.PowerBI.Client.Program.Main(String[] args)
PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.145.1262.0","ModuleName":"","Component":"Microsoft.Mashup.OleDbProvider.DataHost.NonBufferingMashupEvaluator.MashupEvaluation","Error":"Microsoft.Mashup.Host.Document.SerializedException - Microsoft.Mashup.Evaluator.Interface.ErrorException","MethodDef":"OnEvaluationComplete","ErrorOffset":"","ErrorCode":""}
OS Version:
Microsoft Windows NT 10.0.22631.0 (x64 en-US)
CLR Version:
4.8 or later [Release Number = 533320]
Peak Virtual Memory:
71.5 GB
Private Memory:
1.05 GB
Peak Working Set:
1.28 GB
IE Version:
11.1.22621.0
User ID:
81c95168-7211-4a62-bb35-37b9aeed3471
Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: False.
Telemetry Enabled:
True
Snapshot Trace Logs:
C:\Users\michcara\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot45e9bba6-27c1-41e7-a1d2-a10c48239f8e.zip
Model Default Mode:
Composite
Model Version:
PowerBI_V3
Performance Trace Logs:
C:\Users\michcara\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip
Enabled Preview Features:
PBI_scorecardVisual
PBI_setLabelOnExportPdf
PBI_oneDriveSave
PBI_oneDriveShare
PBI_odspSaveBackgroundUpload
PBI_modernOfficeFilePicker
PBI_useModernPublishDialogs
PBI_gitIntegration
PBI_tmdlInDataset
PBI_directLakeRemoteModeling
PBI_directLakeOnOneLake
PBI_newCard
PBI_buttonSlicerAuthoring
PBI_daxInlineCopilot
PBI_aiNarrativesVisual
PBI_generateMeasureDescriptionsButton
PBI_visualCalculationsAuthoring
PBI_tmdlViewToggle
PBI_copilotUnifiedTooling
PBI_UserInstalledVerticaODBCDriver
PBI_sqlDbNativeArtifactsOnDesktop
Disabled Preview Features:
PBI_googleBigQueryAdbcVersionEnabled
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_metricsArtifactsOnDesktop
PBI_b2bExternalDatasetSharing
PBI_enhancedTooltips
PBI_onObject
PBI_publishDialogsSupportSubfolders
PBI_enhancedReportFormat
PBI_advancedSlicerTypeList
PBI_textSlicer
PBI_qnaImproveLsdlCopilot
PBI_UserInstalledNetezzaODBCDriver
MashupFlight_EnableOracleBundledOdacProvider
PBI_dataFunctionActions
Disabled DirectQuery Options:
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
PowerBINonFatalError_ErrorDescription:
Microsoft.Mashup.Evaluator.Interface.ErrorException
PowerBIUserFeedbackServices_IsReported:
True
DPI Scale:
125%
Supported Services:
Power BI
Formulas:
section Section1;
shared DAILY_DDA_ACCT = let
Source = Snowflake.Databases("southstatebank-enterprise.snowflakecomputing.com","S_PRD_SELF_WH"),
S_PRD_FISERV_PREMIER_Database = Source{[Name="S_PRD_FISERV_PREMIER",Kind="Database"]}[Data],
DAILY_Schema = S_PRD_FISERV_PREMIER_Database{[Name="DAILY",Kind="Schema"]}[Data],
DAILY_DDA_ACCT_Table = DAILY_Schema{[Name="DAILY_DDA_ACCT",Kind="Table"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(DAILY_DDA_ACCT_Table,{{"DDA_ACCOUNT", type text}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"INCREMENTAL_KEY", "INSTITUTION_NUMBER", "ACCOUNT_OPEN_METHOD", "ACCOUNT_TYPE", "ACCRUED_INTEREST", "CLOSING_BALANCE", "CURRENT_AVAIL_BALANCE", "DATE_CLOSED", "DATE_LAST_CHANGED", "DATE_LAST_DEPOSIT", "DATE_LAST_NSF", "DATE_OPENED", "DATE_OVERDRAWN", "INITIAL_DEPOSIT", "PORTFOLIO", "MEMO_LEDGER", "ACCOUNTING_GROUP", "ACCT_TYPE_CODE", "BRANCH_NUMBER", "CLASS_CODE", "CLASS_DESCRIPTION", "CLOSED_ACCT_FLAG", "EMPLOYEE_OFFICER_DIRECTOR", "MISC_CODE", "ACQUIRED_BANK_NAME", "ACQUIRED_BANK_CODE_DESCRIPTION", "NOW_NETWORK_OVERRIDE", "OPENED_BY_RESP_CODE", "PRODUCT_DESCRIPTION", "PRODUCT_NUMBER", "RESP_CODE", "STATUS_CODE", "STATUS_CODE_DESC", "ADDITIONAL_CHARGE_OFF", "AUTO_CHG_OFF_OV", "CHARGE_OFF", "CHARGE_OFF_DATE", "CHARGE_OFF_NET", "CHARGE_OFF_RECOVERY", "OVERDRAFT_FEE_LOSS", "OVERDRAFT_LOSS", "SOURCE_OF_FUNDS", "CHARGEOFF_REASON", "ORIGINAL_BRANCH_NUMBER", "BUSINESS_BILLPAY", "BILLPAY_WAIVE", "ROUND_UP_ENROLLMENT_DATE", "SENIOR_BANKING", "EMPLOYEE_BANKING", "STUDENT_BANKING", "STATEMENT_FEE_WAIVER", "TREASURY_NAVIGATOR", "MERCHANT_SERVICES", "LEGACY_BANK", "GL_PAR_NUMBER", "DEPOSIT_RATE_INDEX", "EFFECTIVE_INTEREST_RATE", "INTEREST_EFFECTIVE_DATE", "INTEREST_STRUCTURE_TYPE", "RATE_ADJUSTER", "INTEREST_AVG_BALANCE", "CMTD_AGG_BALANCE", "CMTD_DAYS", "CMTD_AVERAGE_BALANCE", "CURRENT_AVERAGE_BALANCE", "OVERDRAFT_TYPE_CODE", "CYTD_AGG_BALANCE", "CYTD_AGG_AVAIL_BALANCE", "CYTD_DAYS", "CYTD_AVERAGE_BALANCE", "CYTD_AVERAGE_AVAILABLE_BALANCE", "PRIMARY_NAME_ID", "BRANCH_DESCRIPTION", "NAICS_CODE", "NAICS_DESCRIPTION", "OVERDRAFT_BALANCE_LIMIT", "CYTD_INTEREST_PAID", "CYTD_SERVICE_CHARGES", "CYTD_SERVICE_CHARGES_WAIVED", "DOCUMENT_DISTRIBUTION_GROUP", "REFERRAL_RESP_CODE", "CMTD_AVG_EFFECTIVE_INTEREST_RATE", "CMTD_INTEREST_EARNED", "CMTD_INTEREST_PAID", "CMTD_NSF_FEES_WAIVED", "CMTD_NSF_FEES_REFUNDED", "CMTD_SERVICE_CHARGES", "CMTD_SERVICE_CHARGE_WAIVED", "CYTD_INTEREST_EARNED", "COST_CENTER", "ACCOUNT_ORIGIN", "NSF_ITEMS_THIS_RUN"}),
#"Filtered Rows" = Table.SelectRows(#"Removed Columns", each [DDA_ACCOUNT] = "8010002129804")
in
#"Filtered Rows";
shared MDL_MOOV_VCU_BALANCE = let
Source = Snowflake.Databases("southstatebank-enterprise.snowflakecomputing.com","S_PRD_SELF_WH",[Implementation="2.0"]),
P_PRD_MOOV_Database = Source{[Name="P_PRD_MOOV",Kind="Database"]}[Data],
MODEL_Schema = P_PRD_MOOV_Database{[Name="MODEL",Kind="Schema"]}[Data],
MDL_MOOV_VCU_BALANCE_View = MODEL_Schema{[Name="MDL_MOOV_VCU_BALANCE",Kind="View"]}[Data]
in
MDL_MOOV_VCU_BALANCE_View;
shared MDL_MOOV_RECON = let
Source = Snowflake.Databases("southstatebank-enterprise.snowflakecomputing.com","S_PRD_SELF_WH",[Implementation="2.0"]),
P_PRD_MOOV_Database = Source{[Name="P_PRD_MOOV",Kind="Database"]}[Data],
MODEL_Schema = P_PRD_MOOV_Database{[Name="MODEL",Kind="Schema"]}[Data],
MDL_MOOV_RECON_View = MODEL_Schema{[Name="MDL_MOOV_RECON",Kind="View"]}[Data],
#"Filtered Rows" = Table.SelectRows(MDL_MOOV_RECON_View, each [EVENT_READ] <> null and [EVENT_READ] <> "")
in
#"Filtered Rows";
shared PBI_Calendar_Code = let
Source = Table.FromColumns({Lines.FromBinary(File.Contents("C:\Users\michcara\OneDrive - SouthState Bank\Metrics\PBI_Calendar_Code.txt"), null, null, 1252)})
in
Source;
WebView2 Runtime Version:
141.0.3537.71
WebView2 SDK Version:
1.0.2365.46
