Change All Column Types In a Datflow dynamically

[srduval]

I have a report that I am trying to create via a dataflow, where I take a query result from SQL and transpose the data, but this leaves all the columns as an undefined type and the dataflow is wanting all the columns to be of a determined type. The number of columns will change month to month, so I can't explicitly convert them all to text, is there a formula or something I can use in the dataflow power query editor?

[srduval · Accepted solution]

Found this post that seems to do the trick

Solved: Change data type of all columns in a table - Microsoft Fabric Community

let Source = Excel.CurrentWorkbook(){[Name="YourTable"]}[Content],

LSTHeaders = Table.ColumnNames(Source),

HowMany = List.Count(LSTHeaders),

Transformation = Table.TransformColumnTypes( Source, Table.ToRows(Table.FromColumns({LSTHeaders, List.Repeat({type number}, HowMany )})))