Forum Discussion

Iamnvt's avatar
Iamnvt
Continued Contributor
5 years ago
Solved

Dataset Refresh error - Null Value

hi,   Since upgraded to Gateway version Sep, 2020. I got this error:   Underlying error code-2147467259 Underlying error messageMicrosoft SQL: Warning: Null value is eliminated by an aggregate ...
Need Help
  • Iamnvt's avatar
    Iamnvt
    5 years ago

    hi,

     

    Seems like some updates from query folding. I pushed back some of the operations when creating VIEW in SQL server, instead of using query folding feature in Power BI, and it works again.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Probably you are doing a count over a column that contains null values.

Try replacing you SQL statement with 

SELECT COUNT(ISNULL(<fieldname>,0)) if you want to count NULL rows

OR

SELECT SUM(CASE WHEN <fieldname> IS NULL,1,0) if you do not want to count