Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Jimnar_MSFT

Excel Get & Transform feature converting data to upper case

Submitted by on ‎10-26-2017 11:35 PM

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
See more ideas labeled with:
2 Comments (2 New)
Comments
v-jiascu-msft
Microsoft Employee
Microsoft Employee
‎10-29-2017 07:31 PM

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
Impactful Individual
‎10-30-2017 02:52 AM
Status changed to: Declined
 
Idea Statuses