- Power BI forums
- Updates
- News & Announcements
- Get Help with Power BI
- Desktop
- Service
- Report Server
- Power Query
- Mobile Apps
- Developer
- DAX Commands and Tips
- Custom Visuals Development Discussion
- Health and Life Sciences
- Power BI Spanish forums
- Translated Spanish Desktop
- Power Platform Integration - Better Together!
- Power Platform Integrations (Read-only)
- Power Platform and Dynamics 365 Integrations (Read-only)
- Training and Consulting
- Instructor Led Training
- Dashboard in a Day for Women, by Women
- Galleries
- Community Connections & How-To Videos
- COVID-19 Data Stories Gallery
- Themes Gallery
- Data Stories Gallery
- R Script Showcase
- Webinars and Video Gallery
- Quick Measures Gallery
- 2021 MSBizAppsSummit Gallery
- 2020 MSBizAppsSummit Gallery
- 2019 MSBizAppsSummit Gallery
- Events
- Ideas
- Custom Visuals Ideas
- Issues
- Issues
- Events
- Upcoming Events
- Community Blog
- Power BI Community Blog
- Custom Visuals Community Blog
- Community Support
- Community Accounts & Registration
- Using the Community
- Community Feedback
Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
- Power BI forums
- Issues
- Issues
- Error fetching Data from Dynamics Business Central...
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
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";
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
- Hari on: Admin Monitoring Workspace - Dataset has removed f...
-
v-xiaoyan-msft
on:
Report jumps between two profile logins.
- mgast on: Conditional formatting from PowerBI Desktop is not...
- iannedrs on: Error: There is an error in XML document (1, 1).
-
v-xiaoyan-msft
on:
Cannot share PowerBi reorts and dashboards to my o...
-
rayishome
on:
Get External Data: Power BI semantic models throws...
-
v-yetao1-msft
on:
Power BI Desktop April 2024 : Sort by issue. False...
-
rdnguyen
on:
Power BI Service - NetworkConnectionIssue when sav...
-
v-yetao1-msft
on:
Power BI semantic model account sign in for every ...
-
Idrissshatila
on:
Timeline slicer is showing 30 & 31 March under 30 ...
- New 7,841
- Needs Info 3,356
- Investigating 3,127
- Accepted 2,036
- Declined 38
- Delivered 3,743
-
Reports
9,662 -
Dashboards
3,899 -
Data Modeling
3,853 -
Gateways
2,040 -
Report Server
2,001 -
APIS and Embedding
1,882 -
Custom Visuals
1,670 -
Content Packs
502 -
Mobile
347 -
Need Help
11 -
Show and Tell
2 -
General Comment
2 -
Tips and Tricks
1 -
Power BI Desktop
1