Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

"Object reference not set to an instance to an object" when try to group the table in Power Query

I have few SQL tables that i connected with power bi. Already imported all into power bi. But when i try to group the table, this error occured

 

Error message:

DataSource.Error: Microsoft SQL: Object reference not set to an instance to an object.

2 Replies

  • In the past I have seen this error message appear when there is an issue with the file, most often the file cannot find the data model.  Please try save-as with a different file name, close and re-open the file and see if that resolves the issue.

  • Anonymous's avatar
    Anonymous
    Not applicable

    I had this issue , thing i did to resolve was checking null values,variables or expressions in the query, make sure that they are not null or empty. You can do this by adding a check for null values in the query or by using the "IsBlank" function in Power BI.