Changes a column's type in Power Query according to a named source culture; English (United Kingdom), for example, reads dates as day/month/year. Storing this choice in the query means results don't depend on each computer's regional settings.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Using locale in context, with comparison tables and the common traps.
Terms in this definition
- Nonzonal
Describes a resource with no availability zone configuration. Azure can put it in any zone, so it may go offline if that zone fails.
Related terms
- Locale
Determines how Power Query reads dates and numbers stored as text when converting them. By default Power BI Desktop follows the regional format of the operating system; you can override this per file, or per step using Change type > Using locale.
- Table.TransformColumnTypes
Generated whenever Change type assigns column data types in Power Query M. Change type Using locale fills in its optional culture argument, for example "en-GB", which records how text such as dates gets read.