Author: Marco Montoya
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…
Resolve data import errors – Prepare the data
Resolve data import errors Occasionally, you may see errors after you load data in Power…
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:…
Snowflake schema – Model the data
Snowflake schema The snowflake schema is similar to the star schema, except it can have…
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…
Creating parameters – Prepare the data
Creating parameters To create a new parameter in Power Query Editor, on the Home ribbon…
