Category: Resolve data import errors
DirectQuery – Prepare the data
DirectQuery When you use the DirectQuery connectivity mode, you are not caching any data in…
Design a data model – Model the data
Skill 2.1: Design a data model A proper data model is the foundation of meaningful…
Star schema – Model the data
Star schema When you use a star schema, tables are conceptually classified into two kinds:…
Composite models – Prepare the data
Composite models A composite model is a data model that combines imported data and DirectQuery…
Creating parameters – Prepare the data
Creating parameters To create a new parameter in Power Query Editor, on the Home ribbon…
Creating functions – Prepare the data
Creating functions Power Query allows you to create your own functions, which can be useful…
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…
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…
Identify and create appropriate keys for joins – Prepare the data
Identify and create appropriate keys for joins Power BI allows you to combine data from…