Category: Keys for joins in Power Query
DirectQuery – Prepare the data
DirectQuery When you use the DirectQuery connectivity mode, you are not caching any data in…
Resolve data import errors – Prepare the data
Resolve data import errors Occasionally, you may see errors after you load data in Power…
Column properties – Model the data
Column properties For columns, depending on data type, you can configure the following properties: Name…
Creating parameters – Prepare the data
Creating parameters To create a new parameter in Power Query Editor, on the Home ribbon…
Using parameters – Prepare the data
Using parameters Let’s follow an example of how to use parameters in practice: Create a…
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…
Examine data structures and interrogate column properties – Prepare the data
Examine data structures and interrogate column properties In addition to column quality, you can look…
Interrogate data statistics – Prepare the data
Interrogate data statistics You can also profile columns to get some statistics and better understand…
Remove rows – Prepare the data
Remove rows If there are errors in a column, you may wish to remove the…
