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...
I understand. For what its worth, I see the same behaviour in desktop and dataflows, and excel for that matter, so I can't reproduce your issue. I think it is likely you have done something that broke query folding in your desktop example. That is the only explanation, that I can see, for how the results could be different.