View column data types in preview, Power Query

%3CLINGO-SUB%20id%3D%22lingo-sub-3334047%22%20slang%3D%22en-US%22%3EView%20column%20data%20types%20in%20preview%2C%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3334047%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20recently%20switched%20from%20Office%20x32%20-%26gt%3B%20x64%20and%20have%20noticed%20that%20Power%20Query%20seems%20to%20be%20missing%20the%20data%20type%20in%20the%20preview%20for%20each%20column.%20As%20you%20can%20see%20below%2C%20it%20only%20displays%20the%20column%20name%20with%20no%20data%20type%20for%20context.%3C%2FP%3E%3CP%3E%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Ferris_3-1651851815960.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F369867i5E1DB9AD34116404%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Ferris_3-1651851815960.png%22%20alt%3D%22Ferris_3-1651851815960.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECompared%20to%20the%20view%20I%20had%20before%20updating%3C%2FP%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22me-data-types-icons.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F369868i6673F6D0920D47B3%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22me-data-types-icons.png%22%20alt%3D%22me-data-types-icons.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CSPAN%3EIs%20there%20any%20way%20to%20restore%20this%20functionality%3F%20TIA%3C%2FSPAN%3E%3CDIV%20class%3D%22%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3334047%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

Hello,

 

I recently switched from Office x32 -> x64 and have noticed that Power Query seems to be missing the data type in the preview for each column. As you can see below, it only displays the column name with no data type for context.

 Ferris_3-1651851815960.png

 

Compared to the view I had before updating

 me-data-types-icons.png
 
Is there any way to restore this functionality? TIA

 

0 Replies