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.

Iamnvt's avatar
Iamnvt
Continued Contributor
5 years ago

I dont have any count operations, and it was good with previous Gateway.

Only since I upgraded to version Sep, 2020 (or afterward), it occurred the issue.