Skip to main content
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.



Status: Declined

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!


Impactful Individual
Status changed to: Declined