null value is eliminated by an aggregate or other set operation warning

[Anonymous]

Hi All,

I have an issue with table refresh, I get null value is eliminated by an aggregate or other set operation warning.

This prevents the table from refresh. It's connected to SQL view, therefore I cannot ad SET anywhere in the code (or at least I think so, it won't let me save the view). 

I tried ISNULL for the numeric columns, with no luck.

What's more, the view that is connected to PBI does not have any sum/avg/min/max/count function.

The only 'extraordinary' thing is COLLATE.

I'd be really grateful for any input, thanks!

[TeigeGao]

Hi @Anonymous ,

According to your description, this problem should occurs at the SQL Server end, we can check SQL Server error message and create a trace to find what has caused this problem. 

Please check if you have the aggregate function in the view, for SQL Server view, it will be executed every time the view be called. Based on my experience, if you have the aggregate function in the view, and use some sort function like TOP N, some null data may be not included, but when we set different collection at the client, the null data will cause the problem.

Best Regards,

Teige