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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. 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