How to get all Column Names and its Data types in Power Query?

Power Query
1

Hi,

I have a requirement to create a data dictionary for my tables, and I should have column names, and data types in it.

I extracted the column names in Power Query by using Table.ColumnNames(table as table) as list function, I want its Data type beside the column name.

Is there any way where I can get both together?

Like:
Name: Text
ID: Int / WholeNumber

I really appreciate any help you can provide.

2

@Bq1BQfLi Table.Schema

3 Likes
3

Hi @AntrikshSharma

Thanks for your help; it saved me a lot of time.

1 Like