Learn Power BI

True or False: when a table is created from a flat file in Power BI Desktop, the Power Query Editor assumes that the first row of data is the column headers

Two ways to change the data type in Power BI:

Which is more likely to have data type errors

If a column has values that are misspelled, this option in the Transform tab can help

When you append queries, you will be

Which is similar to a SQL JOIN?

This transformation applies aggregation

If you think you might use a column at some point in the future, you should be sure to keep it in the data model so that it is there when you need it.

When doing a merge, which option will guarantee that all rows are included in the result?

Shows % of data that is valid, in error, and empty

A column contains the following rows:

If we replace nulls with 0, how will the average of Shipping_Cost change?

To edit M code directly

Power Query creates which type of code?

When renaming columns, a best practice is to replace underscores ("_") with