Forum Discussion
Error - Object reference not set to an instance of an object
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.
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.