Inspect a Table's Column Types with Table.Schema in Power Query M

Returns a table describing every column's name, data type and other metadata - useful for debugging type mismatches.

Advanced M FunctionsIntermediatetable.schematypesdebugmetadata

Power Query M code

let
    Source = YourTable,
    Schema = Table.Schema(Source)
in
    Schema

Notes

Look at the TypeName column in the result to see each column's actual type, including nullability.

Requirements

A table whose column types you want to inspect.

How to use this snippet

In Power BI Desktop, choose Transform data to open Power Query, then open the Advanced Editor on a query (or start from a blank query).
Paste the snippet and replace the placeholder names (tables, columns, file paths) with your own. Check the requirements above first.
Run it through the Power Query M Formatter to tidy the layout.

More Power Query M resources

Browse all 145 snippets in the Power Query M Code Snippets, or search the library for something similar to Inspect a Table's Column Types with Table.Schema.