Skip to main content

Power BI

New

Allow Case-Insensitive references to column names in SQL Endpoint

Vote (22) Share
Kaila E's profile image

Kaila E on 18 Oct 2023 15:42:07

Ideal behavior would act like SSMS and allow case-insensitive references to column names since some have all caps, some have CamelCase and some are lowercase. It can be difficult to remember which is used in a particular source system table, especially when columns in a single table can have multiple cases applied. SQL Endpoint requires exact case matching which causes headache and confusion for end users.

Comments (1)
Kaila E's profile image Profile Picture

Paul Turley on 01 Nov 2023 18:55:04

RE: Allow Case-Insensitive references to column names in SQL Endpoint

Kaila, I agree and have upvoted your idea. For clarity, your example is Pascal Case where the first letter is capitalized. Camel case looks like this: camelCase.