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 least it always has been until now.
I haven't had a chance to test other functions.
According to my test, the Table.SelectRows() function are case sensitive both in the Power Query and Power BI dataflow, here’s my data source and my test screenshots:
Excel data source:
In Power Query:
In Power BI dataflow:
Thank you very much!
Community Support Team _Robert Qin
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?
In my opinion, if you want to get a solution for this kind of data flow problem as soon as possible, I suggest you to open a support ticket to get direct help from the technical support team of Microsoft to have a remote session them to help you to make sure if this is an issue existing in the Power BI.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.