Type detection
Your first interaction with datatypes in Power Query is likely when you import data. Your data often comes in the form of a table, and the columns for the table can have a data type. When using the default settings, Power Query automatically recognizes the data types of any tables you import. Yet, how Power Query detects the data types of the values in your dataset will depend on the data source used and your Power Query settings. There are two available methods:
- Retrieving data types from data sources
- Automatically detecting types
The following sections look at how these two methods work.
Retrieving data types from a data source
When you import data from a structured data source (e.g., SQL, Oracle, Azure Data Lake, OData feed, etc.), Power Query automatically accesses the table schema from these sources. This table schema is only available in structured data sources and defines the structure of tables in a database. It contains information...