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

[IanDavies]

I have made some changes and updates in Power Query but when I try to close and load the data I get this error.

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 solution]

• 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.​

[MattiaFratello]

Hi @IanDavies,

Try to check for error any DAX calculation such as measures, tables, calculated columns 

Review model relationships to see if any could be broken 

Try to temporarly disable all queries except 1 and load them 1 by 1 to understand if there is a problematic one

You may also want to check for Power BI updates and/or retry to load everything in a new pbix

If this help please give kudos 👍 and accept as solution