Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

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

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!

1 REPLY 1
TeigeGao
Solution Sage
Solution Sage

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors