cancel
Showing results for 
Search instead for 
Did you mean: 

Power Query Online (Dataflows) - not case sensitive

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.

 

KNP_0-1643225527256.png

 

Status: Investigating
Comments
v-robertq-msft
Community Support
Status changed to: Investigating

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:

vrobertqmsft_0-1643249947425.png

 

In Power Query:

vrobertqmsft_1-1643249947428.png

 

In Power BI dataflow:

vrobertqmsft_2-1643249947432.png

 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

KNP
Super User
Super User

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
Community Support

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