I came across what I think is a bug while working on a Dataflow.
It appears that Table.SelectRows is not case sensitive in a Dataflow but is in Desktop.
Obviously it is supposed to be, or at lea...
Hi KNP
Since you say that you are using a SQL server, what I think is most likely happening here is that your query is
being folded into a SQL Query that is delivered directly to the server, and that you are using a database collation that is case insensitive.
The filter expression [Status] = "no d" gets translated into a where filter that looks like this -
where [_].[Status] = 'no d' and [_].[Status] is not null
However the sematics of these two forms can differ, depending on the the collation being used for the database.
See this blog post for more info -
\Anders E. Andersen