The query returned no rows for the dataset. The expression therefore evaluates to null

2017-12-11T11:56:28+00:00 February 22nd, 2013|Azure, Cloud|

Working with BIDS, playing with column visibility for formatting issues and I got the above message when using the following:

=iif(isNothing(QueryValues))

isNothing doesn’t take into consideration empty datasets. To get around it use the following:

=iif(CountRows() = 0, false, true) / =iif(CountRows() = 0, true, false)

Depending on your needs for not visible/visible.

Cheers,

Jason.