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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. 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
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