You use Power Query to import two tables named Order Header and Order Details from an Azure SQL database. The Order Header table relates to the Order Details table by using a column named Order ID in each table.
You need to combine the tables into a single query that contains the unique columns of each table.
What should you select in Power Query Editor?
You merge data from Sales.Region, Region_Manager, Sales_Manager, and Manager into a single table named Region. What should you do next to meet the reporting requirements of the executives?
You publish the dataset to powerbi.com.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
What should you create to meet the reporting requirements of the sales department?