null value is eliminated by an aggregate or other SET operation

[finzilla]

Setting up a client's PBI and one of the tables gives me this error when importing into Desktop. I've used the same view for other clients with the same db structure. Is there a way to bypass the error?

Failed to save modifications to the server. Error returned: 'OLE DB or

ODBC error: [DataSource.Error] Microsoft SQL: Warning: Null value is

eliminated by an aggregate or other SET operation..'.

[v-piga-msft]

Hi @finzilla,

It seems that this error is caused by your data source in Database.

To avoid the warning, you may could use “set ansi_warnings off” before the script. 

You could have a reference in this blog.

https://blog.sqlauthority.com/2015/02/13/sql-server-warning-null-value-is-eliminated-by-an-aggregate...

Hope this can help you!

Best Regards,

Cherry

[NilR]

How can I use “set ansi_warnings off” before the script in PBI?

[Anonymous]

Did you resolve this ?

[NilR]

I added COALESCE ([col],"null") to by pass my issue.  or zero if you have integer.