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...
KNP
Super User
Super UserHi v-robertq-msft,
I assume the XML/JSON comment above was pasted in the wrong post.
The behaviour I'm experiencing doesn't match your tests. Source is SQL Server (on-prem).
If you could test a Dataflow with on-prem SQL with a gateway that may produce different results?
Thanks.