Automatic data type detection

[joshua1990]

Hi experts! 
I have access to a Source that has multiple column, all of them declared as text.

it doesn't matter if there is a date, numbers etc - the source declared everything as a text.

We are talking about multiple tables with a lot of columns.

Now I would like to change this columns into the right format in the Dataflow.

Is there any automatic way to define each column? 

[johnt75 · Accepted solution]

In Power Query, select all the columns ( ctrl-A) then go to the Transform tab and choose "Detect Data Type"