Forum Discussion

HJDataconsult's avatar
HJDataconsult
Regular Visitor
9 years ago

reading sql table column capital or lowercase letter

Hello,   I have imported an sql table in Power BI. one af the columns includes a letter or is blank. for example capital letter L, all articles of an orders are delivered lowercase letter l, so...
Need Help
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi HJDataconsult,

 

Query Editor is case-sensitive while Power Bi is not. There is a workaround that we can use other sign to act as capital or lowercase.

In Query Editor, we add a conditional column as the picture shows.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Best Regards!

Dale