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

Hi Iamnvt,

If you download the pbix file and test on the desktop side, did this issue appears again?
According to your error message, It seems like you are work with SQL data source, any advanced t-SQL statement append in the connector? I'd like to suggest you use SQL profiler to trace the requests to confirm if any issue appears in it.

BTW, you can also take a look at the following link about similar issues if it helps to your scenario:

Warning: Null value is eliminated by an aggregate or other SET operation in Aqua Data Studio 

Regards,

Xiaoxin Sheng