How to count number of columns in Power Query Editor

[Alirezam]

Hey,

This might be a rather boring (read stupid) question, I am dealing with a large file coming in more than 100 columns but I want to know exactly how many columns I am importing into the Power Bi. How can I count them as the Max. showing on the bottom left of the page is frozen at 60.

Thanks

[Syndicate_Admin]

This is what I was looking for . Thank you for the solution.

[PhilipTreacy · Accepted solution]

Hi @Alirezam 

In Power Query you can use the Table.ColumnCount function. So if you load your main data into a table called Table, create a blank query called ColumnCount and use this code in it

let
    Source = Table.ColumnCount(Table)
in
    Source

Regards

Phil