Extract column names and datatype per table

[MrSplinter]

Hi all,

Is it possible to write a query that extracts all column names and datatype for a table in Power BI?

Desired output is a table with two columns, columnname and datatype.

[martapbix]

Is it possible to get it for all the tables at the same time?

[ppm1 · Accepted solution]

Yes. Please see the Table.Schema function.

Table.Schema - PowerQuery M | Microsoft Learn

Pat