Category: Use Microsoft Dataverse
DirectQuery – Prepare the data
DirectQuery When you use the DirectQuery connectivity mode, you are not caching any data in…
Snowflake schema – Model the data
Snowflake schema The snowflake schema is similar to the star schema, except it can have…
Use Microsoft Dataverse – Prepare the data
Use Microsoft Dataverse Power Platform has a family of products that offer similar experiences when…
Using parameters – Prepare the data
Using parameters Let’s follow an example of how to use parameters in practice: Create a…
Creating functions – Prepare the data
Creating functions Power Query allows you to create your own functions, which can be useful…
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…
Evaluate and transform column data types – Prepare the data
Evaluate and transform column data types If the data source does not communicate the type…
Reducing rows and columns – Prepare the data
Reducing rows and columns Since the first three rows don’t contain any meaningful data, we…