Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.

Excel Get & Transform feature converting data to upper case

I have created a very simple query with Excel Get & Transform, the result of which is pulling just two records from two other Excel source files. They look great in the preview, but one of rows includes data with column that gets capitalized when it is loaded into Excel (screen shot included). Is this expected behavior, because it certainly wasn't what I expected.

 

gandtissue_blurred.png

Status: Declined
Comments
v-jiascu-msft
Microsoft Employee

Hi @Jimnar_MSFT,

 

Since you asked a question about Excel, please go to Office Forum for professional help.

 

BTW, there is no issues in the latest Power BI Desktop and Excel 2016.

 

Best Regards!

Dale

Vicky_Song
Impactful Individual
Status changed to: Declined