For more information about Power Query formulas, see Create Power Query formulas in Excel. Each query step has a corresponding Power Query formula, also known as the "M" language. Summary: Power Query steps created in Task 1Īs you perform query activities in Power Query, query steps are created and listed in the Query Settings pane, in the Applied Steps list. The query appears in a new Excel worksheet. In this step, you load the Products query into an Excel worksheet.
Select Remove Columns > Remove Other Columns. In Data Preview, select the ProductID, ProductName, CategoryID, and QuantityPerUnit columns (use Ctrl+Click or Shift+Click). In this step you remove all columns except ProductID, ProductName, CategoryID, and QuantityPerUnit. Step 3: Remove other columns to only display columns of interest Select the down arrow to the right of the formula bar to see the complete formula. This step was created by Power Query which inferred the data types of each column. Right click the Changed Type step, and select Edit Settings. This step was created when you selected the table from the Navigation dialog box. Right click the Navigation step, and select Edit Settings. This step was created when you imported the workbook. Right click the Source step, and select Edit Settings. Examine each step under Applied Steps in the Query Settings pane to learn more. The Power Query Editor appears.īy default, Power Query automatically adds several steps as a convenience for you. In the Navigator pane, double click the Products table. In the Import Data dialog box, browse for and locate the Products.xlsx file you downloaded, and then select Open. Select Data > Get Data > From File > From Workbook. In this task, you import products from the Products and Orders.xlsx (downloaded and renamed above) file into an Excel workbook, promote rows to column headers, remove some columns, and load the query to a worksheet.
0 kommentar(er)
