Blog Post

Excel Blog
2 MIN READ

Announcing Power Query Data Types

jokahati's avatar
jokahati
Icon for Microsoft rankMicrosoft
Oct 29, 2020
We are excited to announce a new and exciting update to Get & Transform Data capabilities in Excel – Power Query data types! This tool will help you organize your data better and consume it easily. ...
Updated Oct 19, 2020
Version 1.0
excel
Power Query
Phil Trick's avatar
Phil Trick
Copper Contributor
Dec 29, 2020

Custom Data Types cannot have hierarchical records without flattening them out first and re-creating a new custom object.

 

Another missing feature is a tie-in with dynamic arrays. A Custom Data Type with a List object within one of the properties would be an exceptional opportunity.

 

Any chance these types of features are in the works?