Forum Discussion
Anonymous
3 years agoNot applicable
"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
- jennratten
Super User
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.
- AnonymousNot 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.