Search
  • Reviewed by Maslows

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.

Background

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?

  1. Click the mouse anywhere in the table

  2. Press Ctrl + a (check all)


Check the whole table with Ctrl + a

  1. 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.

0 views