Power query to import column data types from table

Hi Guys,

this is a crossed post from here:

https://community.fabric.microsoft.c...623105#M148668

Need a power query to change ColumnTransformTypes step automatically.
It means that i want to specify column type from external table, not using power query automatic option to change data types.

Can anybody help with power query to achive that ?

It should be some kind of vlookup checking TableName, TableColumn and applying specific column data type.

Best Wishes,
Jacek

Sample:
ColumnDataTypes.xlsx

Please Login or Register  to view this content.

ColumnDataTypes.xlsx

Thank you,

very interesting approach.

Best,
Jacek