Error - Object reference not set to an instance of an object

Question

I have made some changes and updates in Power Query but when I try to close and load the data I get this error.&nbsp;There are no errors shown in any table/query in the Power Query Editor.How do I troubleshoot the cause of this, my whole report is now unuseable

shubham_rai955 · Accepted Answer

Try restarting Power BI and reopen your report; sometimes this fixes temporary glitches.​Check if you have any queries with missing or deleted steps, or references to objects (tables, columns) that no longer exist; even hidden steps can cause this.​Remove any recently added custom columns or steps one-by-one to see if the error goes away.Copy all important queries to a new blank Power BI file; sometimes this allows you to narrow down which query is causing the problem.Update Power BI Desktop to the latest version if you haven't already.​If none of these work, restore your file from a backup before the error started and redo changes carefully.​

Forum Discussion

Related content

Error-Object reference not set to an instance of an object

Opening Desktop: Object reference not set to an instance of an object

Error: Object reference not set to an instance of an object

Object reference not set to an instance of an object.

Object reference not set to an instance of an object.