Automatically detect and change the types of all columns at once in Power Query from Power BI – The
Today I want to share quick tip on how to automatically detect and change all column types at once in Power Query.
Very often, when you expand a column in Power Query that contains a table or some records, the expanded columns will lose their types (like Chris Webb has described here for example). Or you might just have accidently deleted a “Changed Type”-step.
No types on columns
Did you know there is actually a superfast and easy way to do it?
Click the mouse anywhere in the table
Press Ctrl + a (check all)
Check the whole table with Ctrl + a
Go to the Transform-tab ad choose: “Detect Data Type”
Transform with 1 click
Voila: All your columns should have types on them.
They have been automatically been detected by checking the first 100 rows of your table. So if you know that you’re having columns with inconsistent values in them, make sure to check the automatically assigned values.
Enjoy & stay queryious 😉
The post Automatically detect and change the types of all columns at once in Power Query appeared first on The BIccountant.