Skip to main content

Power BI

New

Preserve data types when expanding table columns

Vote (21) Share
Marcel Beugelsdijk's profile image

Marcel Beugelsdijk on 10 Jan 2017 15:32:21

With the function Table.ExpandTableColumn, a column with nested tables can be expanded. However, the data types of the columns of the nested tables are not applied to the new columns after expansion.
This behaviour is different from Table.ExpandRecordColumn, where data types of the nested records are applied to the new columns after expansion.
So this should also be possible with Table.ExpandTableColumn.

This will also further improve the "combine binaries" functionality that was already strongly improved with the November 2016 update of Power BI Desktop:
currently, you still have to change data types after combining binaries, while these data types may have been explicitly defined in the sample query that is created from "combining binaries".

Comments (1)
Marcel Beugelsdijk's profile image Profile Picture

8644b408 a7a3-4a2b-a4a5-c60ed8962a63 on 05 Jul 2020 22:37:37

RE: Preserve data types when expanding table columns

This may be related to: http://community.powerbi.com/t5/Issues/combine-binaries-on-csv-not-flowing-Type-Change-to-final-output/idc-p/111106#M1515