Power Query Online (Dataflows) - not case sensitive

[KNP]

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.

[v-robertq-msft]

Hi,

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!

Best Regards,

Community Support Team _Robert Qin

[KNP]

Hi @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.

[v-robertq-msft]

Hi, 

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.

https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

https://powerbi.microsoft.com/en-us/support/

Thank you very much!

Best Regards,

Community Support Team _Robert Qin