cancel
Showing results for 
Search instead for 
Did you mean: 

Error fetching Data from Dynamics Business Central 365 (SaaS Version)

I am getting errors when reloading Data from BC.

I think it is an Authentication Issue, caused by a password change, but i am not sure.

 

 

Error Mesage here, redacted some data:

 

Feedback Type:
Frown (Error)

Error Message:
Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

Stack Trace:
bei Microsoft.Mashup.Evaluator.ChannelMessenger.CreateChannel()
bei Microsoft.PowerBI.Client.OleDbProvider.PowerBIMashupDataSource.EvaluationSession.Dispose()
bei Microsoft.Mashup.Host.ProviderShared.PackageMashupEvaluator.<>c__DisplayClass7_0.<Evaluate>b__1(Object o)
bei Microsoft.Mashup.Evaluator.Interface.InvokeManyAction`1.CheckDone()
bei Microsoft.Mashup.OleDbProvider.DataHost.MashupEvaluator.<>c__DisplayClass4_1.<Evaluate>b__1()
bei Microsoft.Mashup.OleDbProvider.DataHost.AsyncResultIDataReaderSourceHelper.InvokeThenOnDispose(Action`1 callback, AsyncResult`1 result, Action action)
bei Microsoft.Mashup.OleDbProvider.DataHost.MashupEvaluator.<>c__DisplayClass4_0.<Evaluate>b__0(EvaluationResult2`1 result)
bei Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose(Action`1 callback, EvaluationResult2`1 result, Action action)
bei Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose[T](Action`1 callback, EvaluationResult2`1 result, Action action)
bei Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluation`1.Complete(EvaluationResult2`1 result)
bei Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose(Action`1 callback, EvaluationResult2`1 result, Action action)
bei Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose[T](Action`1 callback, EvaluationResult2`1 result, Action action)
bei Microsoft.Mashup.Evaluator.DocumentEvaluator.<>c__DisplayClass7_0`1.<BeginGetResult>b__0(EvaluationResult2`1 result)
bei Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose(Action`1 callback, EvaluationResult2`1 result, Action action)
bei Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose[T](Action`1 callback, EvaluationResult2`1 result, Action action)
bei Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluation`1.Complete(EvaluationResult2`1 result)
bei Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation`1.TryComplete(EvaluationResult2`1 result)
bei Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation`1.TryCompleteWithException(Exception exception)
bei Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation.Evaluate(Boolean enableFirewall)
bei Microsoft.Mashup.Evaluator.EvaluatorThreadPool.EvaluatorThread(Object state)
bei Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass9_0.<CreateAction>b__0(Object o)

Stack Trace Message:
Der Objektverweis wurde nicht auf eine Objektinstanz festgelegt.

Invocation Stack Trace:
bei Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
bei Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage)
bei Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e)
bei Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
bei Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass14_0.<HandleException>b__0()
bei Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass0_1.<SendAndMarshalExceptions>b__0(Object null)
bei System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
bei System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
bei System.Delegate.DynamicInvokeImpl(Object[] args)
bei System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
bei System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
bei System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
bei System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
bei System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
bei System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
bei System.Windows.Forms.Control.InvokeMarshaledCallbacks()
bei System.Windows.Forms.Control.WndProc(Message& m)
bei System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
bei System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
bei System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
bei System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
bei System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
bei System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
bei System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
bei Microsoft.PowerBI.Client.Windows.CefHtmlForm.<>n__0(IWindowHandle windowHandle)
bei Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
bei Microsoft.PowerBI.Client.Windows.FloatingDialog.KoLoadToReportDialog.TryShowDialog(Report report, IExceptionHandler exceptionHandler, IPowerBIWindowService windowService, IQueryServices queryServices, IModelingService modelingService, IUIHost uiHost, LocalizedString title, LoadToModelContext loadToModelContext, IEventAggregationService eventAggregationService)
bei Microsoft.PowerBI.Client.Windows.Commands.ApplicationCommands.DataImportCommands.RefreshAllQueries(IPowerBIWindowService windowService, IExceptionHandler exceptionHandler, RefreshAllQueriesParameters parameters)
bei Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
bei Microsoft.Practices.Prism.Commands.DelegateCommandBase.<>c__DisplayClass4_0.<.ctor>b__0(Object arg)
bei Microsoft.Practices.Prism.Commands.DelegateCommandBase.<Execute>d__10.MoveNext()
bei System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
bei Microsoft.Practices.Prism.Commands.DelegateCommandBase.Execute(Object parameter)
bei Microsoft.Practices.Prism.Commands.DelegateCommand`1.<Execute>d__5.MoveNext()
bei System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine](TStateMachine& stateMachine)
bei Microsoft.Practices.Prism.Commands.DelegateCommand`1.Execute(T parameter)
bei Microsoft.PowerBI.Client.Windows.Commands.CompositeCommand`1.Execute(ICommand command, Object parameter)
bei Microsoft.Practices.Prism.Commands.CompositeCommand.Execute(Object parameter)
bei Microsoft.PowerBI.Client.Windows.Commands.CompositeCommand`1.Execute(T parameter)
bei Microsoft.PowerBI.Client.Windows.CommandStoreHostService.<>c__DisplayClass13_0.<Execute>b__0()
bei Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
bei System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
bei System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
bei System.Delegate.DynamicInvokeImpl(Object[] args)
bei System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
bei System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
bei System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
bei System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
bei System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
bei System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
bei System.Windows.Forms.Control.InvokeMarshaledCallbacks()
bei System.Windows.Forms.Control.WndProc(Message& m)
bei System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
bei System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
bei System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
bei System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
bei System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
bei System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
bei System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
bei Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>n__0(IWindowHandle owner)
bei Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
bei Microsoft.PowerBI.Client.Program.<>c__DisplayClass1_0.<Main>b__1()
bei Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()
bei Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
bei Microsoft.PowerBI.Client.Program.Main(String[] args)


PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.82.5858.1121","ModuleName":"","Component":"","Error":"Microsoft.Mashup.Host.Document.SerializedException - System.NullReferenceException","MethodDef":"","ErrorOffset":""}

Snapshot Trace Logs:
C:\Users\USERNAME\Microsoft\Power BI Desktop Store App\FrownSnapShot753196414.zip

Model Default Mode:
Import

Model Version:
PowerBI_V1

Is Report V3 Models Enabled:
False

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

Enabled Preview Features:
PBI_NewWebTableInference
PBI_modelViewASLiveConnect

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_inlineExplore
PBI_v3ModelsPreview
PBI_relativeTimeSlicer
PBI_dataSearchCuration

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

PowerBINonFatalError_ErrorDescription:
System.NullReferenceException

Formulas:


section Section1;

shared EinkaufsbestellungPurchLines = let
Quelle = Dynamics365BusinessCentral.EnvironmentContents(null, null),
PRODUCTION = Quelle{[Name="PRODUCTION"]}[Data],
#"THECOMPANYNAME" = PRODUCTION{[Name="THECOMPANYNAME"]}[Data],
EinkaufsbestellungPurchLines_table = #"THECOMPANYNAME"{[Name="EinkaufsbestellungPurchLines",Signature="table"]}[Data]
in
EinkaufsbestellungPurchLines_table;

shared Einkaufsbestellung = let
Quelle = Dynamics365BusinessCentral.EnvironmentContents(null, null),
PRODUCTION = Quelle{[Name="PRODUCTION"]}[Data],
#"THECOMPANYNAME" = PRODUCTION{[Name="THECOMPANYNAME"]}[Data],
Einkaufsbestellung_table = #"THECOMPANYNAME"{[Name="Einkaufsbestellung",Signature="table"]}[Data]
in
Einkaufsbestellung_table;

shared Artikelkarte = let
Quelle = Dynamics365BusinessCentral.EnvironmentContents(null, null),
PRODUCTION = Quelle{[Name="PRODUCTION"]}[Data],
#"THECOMPANYNAME" = PRODUCTION{[Name="THECOMPANYNAME"]}[Data],
Artikelkarte_table = #"THECOMPANYNAME"{[Name="Artikelkarte",Signature="table"]}[Data]
in
Artikelkarte_table;

shared Debitorenkarte = let
Quelle = Dynamics365BusinessCentral.EnvironmentContents(null, null),
PRODUCTION = Quelle{[Name="PRODUCTION"]}[Data],
#"THECOMPANYNAME" = PRODUCTION{[Name="THECOMPANYNAME"]}[Data],
Debitorenkarte_table = #"THECOMPANYNAME"{[Name="Debitorenkarte",Signature="table"]}[Data]
in
Debitorenkarte_table;

shared Montagestückliste = let
Quelle = Dynamics365BusinessCentral.EnvironmentContents(null, null),
PRODUCTION = Quelle{[Name="PRODUCTION"]}[Data],
#"THECOMPANYNAME" = PRODUCTION{[Name="THECOMPANYNAME"]}[Data],
Montagestückliste_table = #"THECOMPANYNAME"{[Name="Montagestückliste",Signature="table"]}[Data]
in
Montagestückliste_table;

shared Lagerplätze = let
Quelle = Dynamics365BusinessCentral.EnvironmentContents(null, null),
PRODUCTION = Quelle{[Name="PRODUCTION"]}[Data],
#"THECOMPANYNAME" = PRODUCTION{[Name="THECOMPANYNAME"]}[Data],
Lagerplätze_table = #"THECOMPANYNAME"{[Name="Lagerplätze",Signature="table"]}[Data]
in
Lagerplätze_table;

shared Kreditorenkarte = let
Quelle = Dynamics365BusinessCentral.EnvironmentContents(null, null),
PRODUCTION = Quelle{[Name="PRODUCTION"]}[Data],
#"THECOMPANYNAME" = PRODUCTION{[Name="THECOMPANYNAME"]}[Data],
Kreditorenkarte_table = #"THECOMPANYNAME"{[Name="Kreditorenkarte",Signature="table"]}[Data]
in
Kreditorenkarte_table;

shared Power_BI_Purchase_List = let
Quelle = Dynamics365BusinessCentral.EnvironmentContents(null, null),
PRODUCTION = Quelle{[Name="PRODUCTION"]}[Data],
#"THECOMPANYNAME" = PRODUCTION{[Name="THECOMPANYNAME"]}[Data],
Power_BI_Purchase_List_table = #"THECOMPANYNAME"{[Name="Power_BI_Purchase_List",Signature="table"]}[Data]
in
Power_BI_Purchase_List_table;

shared Power_BI_Purchase_Hdr_Vendor = let
Quelle = Dynamics365BusinessCentral.EnvironmentContents(null, null),
PRODUCTION = Quelle{[Name="PRODUCTION"]}[Data],
#"THECOMPANYNAME" = PRODUCTION{[Name="THECOMPANYNAME"]}[Data],
Power_BI_Purchase_Hdr_Vendor_table = #"THECOMPANYNAME"{[Name="Power_BI_Purchase_Hdr_Vendor",Signature="table"]}[Data]
in
Power_BI_Purchase_Hdr_Vendor_table;

shared Power_BI_Aged_Inventory_Chart = let
Quelle = Dynamics365BusinessCentral.EnvironmentContents(null, null),
PRODUCTION = Quelle{[Name="PRODUCTION"]}[Data],
#"THECOMPANYNAME" = PRODUCTION{[Name="THECOMPANYNAME"]}[Data],
Power_BI_Aged_Inventory_Chart_table = #"THECOMPANYNAME"{[Name="Power_BI_Aged_Inventory_Chart",Signature="table"]}[Data]
in
Power_BI_Aged_Inventory_Chart_table;

shared Power_BI_Item_Purchase_List = let
Quelle = Dynamics365BusinessCentral.EnvironmentContents(null, null),
PRODUCTION = Quelle{[Name="PRODUCTION"]}[Data],
#"THECOMPANYNAME" = PRODUCTION{[Name="THECOMPANYNAME"]}[Data],
Power_BI_Item_Purchase_List_table = #"THECOMPANYNAME"{[Name="Power_BI_Item_Purchase_List",Signature="table"]}[Data]
in
Power_BI_Item_Purchase_List_table;

shared Power_BI_Vendor_List = let
Quelle = Dynamics365BusinessCentral.EnvironmentContents(null, null),
PRODUCTION = Quelle{[Name="PRODUCTION"]}[Data],
#"THECOMPANYNAME" = PRODUCTION{[Name="THECOMPANYNAME"]}[Data],
Power_BI_Vendor_List_table = #"THECOMPANYNAME"{[Name="Power_BI_Vendor_List",Signature="table"]}[Data]
in
Power_BI_Vendor_List_table;

shared Purchase_Order_Line = let
Quelle = Dynamics365BusinessCentral.EnvironmentContents(null, null),
PRODUCTION = Quelle{[Name="PRODUCTION"]}[Data],
#"THECOMPANYNAME" = PRODUCTION{[Name="THECOMPANYNAME"]}[Data],
Purchase_Order_Line_table = #"THECOMPANYNAME"{[Name="Purchase_Order_Line",Signature="table"]}[Data]
in
Purchase_Order_Line_table;

shared purchaseDocumentLines = let
Quelle = Dynamics365BusinessCentral.EnvironmentContents(null, null),
PRODUCTION = Quelle{[Name="PRODUCTION"]}[Data],
#"THECOMPANYNAME" = PRODUCTION{[Name="THECOMPANYNAME"]}[Data],
purchaseDocumentLines_table = #"THECOMPANYNAME"{[Name="purchaseDocumentLines",Signature="table"]}[Data]
in
purchaseDocumentLines_table;

shared purchaseDocuments = let
Quelle = Dynamics365BusinessCentral.EnvironmentContents(null, null),
PRODUCTION = Quelle{[Name="PRODUCTION"]}[Data],
#"THECOMPANYNAME" = PRODUCTION{[Name="THECOMPANYNAME"]}[Data],
purchaseDocuments_table = #"THECOMPANYNAME"{[Name="purchaseDocuments",Signature="table"]}[Data]
in
purchaseDocuments_table;

shared ItemNO_IQC_flag = let
Quelle = Excel.Workbook(Web.Contents("https://docs.google.com/spreadsheets/d/SPREADSHEET_ID"), null, true),
ItemNO_IQC_flag_Sheet = Quelle{[Item="ItemNO_IQC_flag",Kind="Sheet"]}[Data],
#"Höher gestufte Header" = Table.PromoteHeaders(ItemNO_IQC_flag_Sheet, [PromoteAllScalars=true]),
#"Geänderter Typ" = Table.TransformColumnTypes(#"Höher gestufte Header",{{"ItemNumber", type text}, {"Sampling required", type logical}})
in
#"Geänderter Typ";

Status: New
Comments
v-yuta-msft
Community Support

@benovic ,

 

I'm afraid it's hard to reproduce this issue on my side. I would suggest you refer to doc and similar case below:

https://docs.microsoft.com/en-us/dynamics365/business-central/admin-powerbi#troubleshooting

https://community.powerbi.com/t5/Desktop/Dynamics-365-Business-Central-on-premises-Authentication-Er...

 

Regards,

Jimmy Tao