Category: Identify data anomalies
DirectQuery – Prepare the data
DirectQuery When you use the DirectQuery connectivity mode, you are not caching any data in…
Apply user-friendly naming conventions to columns and queries – Prepare the data
Apply user-friendly naming conventions to columns and queries When you create your data model in…
Column properties – Model the data
Column properties For columns, depending on data type, you can configure the following properties: Name…
Composite models – Prepare the data
Composite models A composite model is a data model that combines imported data and DirectQuery…
Use Microsoft Dataverse – Prepare the data
Use Microsoft Dataverse Power Platform has a family of products that offer similar experiences when…
Clean, transform, and load the data – Prepare the data
Skill 1.2: Clean, transform, and load the data Unless you are connecting to a dataset…
Identify data anomalies – Prepare the data
Identify data anomalies Power Query provides different functionality for identifying data anomalies depending on what…
Interrogate data statistics – Prepare the data
Interrogate data statistics You can also profile columns to get some statistics and better understand…
Resolve inconsistencies, unexpected or null values, and data quality issues – Prepare the data
Resolve inconsistencies, unexpected or null values, and data quality issues If you followed the Wide…
Using locale – Prepare the data
Using locale Occasionally, you will need to transform data by using a certain locale. For…