change_column_type
Set data types for columns in Power BI tables by specifying column:type pairs, optionally using a culture to avoid silent type-conversion errors.
Instructions
Power Query Change Type: set the data type of one or more columns. Appends Table.TransformColumnTypes to the table's M query. types is comma-separated as column:type, e.g. "Amount:number,OrderDate:date,Qty:int". type = text | int | number | date | datetime | bool | currency. Pass culture (e.g. "en-US", "en-NZ") to parse text against that locale's date/number conventions - the fix for silent type-conversion corruption on mixed-locale sources.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | ||
| types | Yes | column:type pairs, comma-separated | |
| culture | No | locale/culture for parsing, e.g. en-US (optional) | |
| sessionId | Yes | ||
| partitionName | No | partition name (optional; defaults to the first partition) |