Object reference not set to an instance of an object

[Anonymous]

I'm getting this error - what could that be?

Feedback Type:
Frown (Error)

Timestamp:
2020-03-19T03:33:37.6006206Z

Local Time:
2020-03-19T04:33:37.6006206+01:00

Session ID:
8a1b724b-b10f-4a10-b2d0-08d81840f2fe

Release:
March 2020

Product Version:
2.79.5768.721 (20.03) (x64)

Stack Trace:
at Microsoft.PowerBI.Client.Windows.FloatingDialog.KoLoadToReportDialog.EvaluationOrLoadHadErrorsForAnyQuery()
at Microsoft.PowerBI.Client.Windows.FloatingDialog.KoLoadToReportDialog.<DisplayErrorOrClose>d__25.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Windows.FloatingDialog.KoLoadToReportDialog.<>c__DisplayClass32_0.<<StartLoadToReportFlow>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<HandleAwaitableAsyncExceptions>d__1.MoveNext()

OS Version:
Microsoft Windows NT 10.0.18363.0 (x64 sl-SI)

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

Peak Virtual Memory:
39.9 GB

Private Memory:
1.42 GB

Peak Working Set:
1.81 GB

IE Version:
11.657.18362.0

User ID:
dd2d8bde-c05a-4b83-bb29-3863cf0f10c5

Workbook Package Info:
1* - en-GB, Query Groups: 69, fastCombine: Enabled, runBackgroundAnalysis: False.

Telemetry Enabled:
True

Snapshot Trace Logs:
C:\Users\turk\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot130145405.zip

Model Default Mode:
Import

Model Version:
PowerBI_V1

Is Report V3 Models Enabled:
False

Enabled Preview Features:
PBI_showMinervaRibbon
PBI_showMinervaViewNavigator

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

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
125%

Supported Services:
Power BI

[v-qiuyu-msft]

Hi @Anonymous

Which steps did you take in Power BI desktop then causes this issue? Please clarify it clearly. 

Best Regards,
Qiuyun Yu

[Sudheerv]

Hi @v-qiuyu-msft ,

When ever I open an existing file, receiving the error message: Object reference not set to an instance of an object. I have tried updating the windows, uninstalled and installed the Power BI Desktop. But still the issue persists.  But where as my friends are able to access the same file.  I have downloaded the same file which they are able to access from the service and tried accessing it. But still unable to access the files from yesterday.  I have even reported the issue also.

[Sudheerv]

Hi @v-qiuyu-msft ,

I'm also facing the same issue.

Unable to access the reports in desktop. 

Please do the needful. 

[v-qiuyu-msft]

Hi all, 

Please start Power BI desktop as administrator, then click on File -> Open to see if the same issue occurs. Also please ensure the pbix file is saved in local drive rather than network drive. 

Best Regards,
Qiuyun Yu

[Sudheerv]

Hi @v-qiuyu-msft ,

Tried opening Power BI desktop as administrator,  then File -> Open, selected the file which was copied earlier to desktop. Still the issue persists. 

[v-qiuyu-msft]

Hi all, 

Please check if the anti-virus software block the related Power BI desktop processes. If not, I would suggest you create a support ticket to let engineers look into the issue on your side. 

Best Regards,
Qiuyun Yu

[ericOnline]

I'm receiving this same error. 

[im_newbie_123]

Getting the same error : 

Object reference not set to an instance of an object.

[dkapinos]

I'd like to share my researches. There are installed MS office 2019 and the latest version of PBI: 2.88.1385.0 64-bit (Dec 2020). I've  set 2 different type connections to the same Oracle (12C) databse: ODAC and ODBC. Both of them work fine from Excel. However, trying to use an ODAC connection from PBI got  a msg: "Object reference not set to an instance of an object". Then i have created an ODBC conection. Successful. Then i've created the ODAC as a second connection to the same DB. Successful as well. Finally I've deleted the ODBC connection, refreshed and seen "Object reference not set to an instance of an object" again. Any ideas?

[Patryk_PL_92]

I encoutered same problem today.

In my case there was problem with data model.

Simply, my data sources are coming from various excel files which are stored in various Sharepoint Folders.

For some reason - Power BI (PQ) has pulled all columns available in excel file which is around 10000 (no matter those were blank). There was a step to add custom column "Connector", it could not be added as PQ reached limit of columns (there was no error notification in PQ which is strange).

Because of that, data from this table did not have any relationship with other tables and refreshing was impossible.

I fixed that by removing all null columns.

Then custom column could be added and relationship with other columns has been restored.