object reference not set to an instance of object

[VamshiKumar]

My pbix file not opening for the last 3 days, in which i had done a lot work and now it is showing error : object reference not set to an instance of an object. I raised a support ticket too but issue not solved till now. im in march update when this error occured. I have done reinstalling and downngrading to febrauary version but still no use. Please Find the traces below.

Feedback Type:
Frown (Error)

Timestamp:
2020-04-10T06:23:35.3714173Z

Local Time:
2020-04-10T11:53:35.3714173+05:30

Session ID:
4f2dd87c-ea0b-48a8-b1ea-4af20891fff4

Release:
March 2020

Product Version:
2.79.5768.1082 (20.03) (x64)

Stack Trace:
at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source, Func`2 predicate)
at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesCallbackHelper.AddSqlCredentialsToConnectionString(Report report, IPowerBIWindowService windowService, IUIHost uiHost, IExceptionHandler exceptionHandler, IUIBlockingService uiBlockingService, ILoadToModelQueryEvaluatorFactory evaluatorFactory, SqlCredentialsRequestMessage requestMessage)
at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesLoadContextFactory.OnSqlCredentialsMessage(IMessageChannel channel, SqlCredentialsRequestMessage requestMessage)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel)
at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message)
at Microsoft.PowerBI.Client.Windows.AnalysisServices.AnalysisServicesLoadContextFactory.MessageDispatchWorker(NamedPipeServerStream inputPipeStream, NamedPipeServerStream outputPipeStream, IMessenger messenger)
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

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

CLR Version:
4.7 or later [Release Number = 528040]

Peak Virtual Memory:
39.4 GB

Private Memory:
1.44 GB

Peak Working Set:
1.46 GB

IE Version:
11.719.18362.0

User ID:
6b3f4e3d-5728-403e-a022-bbae3a193d83

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

Telemetry Enabled:
True

Snapshot Trace Logs:
C:\Users\AGSPLCORP04\Microsoft\Power BI Desktop Store App\FrownSnapShot1399194960.zip

Model Default Mode:
Empty

Model Version:
PowerBI_V1

Is Report V3 Models Enabled:
False

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_NewWebTableInference
PBI_qnaLiveConnect
PQ_AIInsightsFunctionBrowser
PBI_realTimeRefresh
PBI_showMinervaRibbon
PBI_showMinervaViewNavigator
PBI_v3Models
PBI_decompositionTree
PBI_themeDialog
PBI_hierarchicalSlicerCreation

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

[v-qiuyu-msft]

Hi @VamshiKumar, 

As you already created a support ticket to Microsoft, please keep contacting the ticket owner for help till the issue is resolved. It would be better if you could post the solution here which will benefit other users who might have the same issue. 

Best Regards,
Qiuyun Yu

[VamshiKumar]

Hi @v-qiuyu-msft The issue is solved by providing the previous data model which is working fine to the effetced file. I could solve this by the suggestions from the one of the product team member from support.

[Anonymous]

Hi @VamshiKumar,

• Object reference not set to an instance of an object

This is usually happens due to presence of empty cells don’t have null value. To figure out which sheet contains these cells, refresh the file. During the refresh, the error will appear in the culprit sheet saying for example “Customers sheet contains empty cells in the emails column”.

You have to fill these cells either with null value or the missing data.

 best regards,