The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredAsk the Fabric Databases & App Development teams anything! Live on Reddit on August 26th. Learn more.
In Power Query, the current Table.ExpandTableColumn function does not allow users to submit the datatype for the columns like so many other functions allow. It forces us to create an additional step to then identify the columns data type. It would be even better if it kept the same data types from previous steps (Specifically the group by function as a previous step). However, if that is not possible, it would be great if we could update it from...
Current Algorithm:
= Table.ExpandTableColumn(#"Grouped Rows by Name", "Index", {"Original Position","Position","Department", "Status", "Index"}, {"Original Position","Position", "Department", "Status", "Index"})
Future Algorithm:
= Table.ExpandTableColumn(#"Grouped Rows by Name", "Index", {"Original Position","Position","Department", "Status", "Index"}, {{"Original Position", type text},{"Position", type text},{ "Department", type text}, {"Status", type text}, {"Index", Int64.type}})
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.