Exam PL-300 topic 1 question 9 discussion

Import From Excel Append Table 2 to Table 1 Remove Duplicates

Import From Excel since it has not been loaded to Powerbi initially Append Table 2 to Table 1 Remove Duplicates from the table appended to (Table1)

Import both the data sets to power query editor and then append both of them into single table, then remove errors from the appended table.

The given answer works. I see many going for import but in the import statement it is mentioned to select two table which is not needed to append

I think to assume tables are already loaded in Power BI Desktop because the question is mentioning we need to use Power Query Editor is little too much, exam is not about English language but PBI knowledge so, in my opinion, first answer should be 1.- From Power BI Desktop, import the data from Excel and select Table 1 and Table 2 No discussion about second answer: 2.- From Power Query Editor, append Table 2 to Table 1 I was surprised with the "Remove Errors" step proposed as a solution, why that step when no errors should be expected out of specific tables of the exercise? I can confirm this step is not needed for this specific exmple I checked it in PBI and it's adding absolutely no vlue to the final result, therefore, third answer should be 3.- From Power Query Editor select Table 1 and then select Remove Duplicates Not an option here but, wheusing Merge and/or Append, last step should be disabling load data from the secondary table

The question says from power query. Meaning the data has already been imported from excel and now you need to list the steps in power query. It’s a tricky question

If the question specifies using Power Query Editor in Power BI, the steps should focus on how to manage data directly within Power BI rather than assuming the data is already loaded from Excel. So the answer is correct

D E A, pls revise the answer

Load both tables into Power Query Editor: Open Power Query Editor and import Sheet1 and Sheet2 from the Excel workbook. This will make Table1 and Table2 available for manipulation. Append Queries: Append Table1 and Table2 to combine the rows from both tables into a single table. This creates a unified table with all products listed. Remove Duplicates: Apply the "Remove Duplicates" transformation to the appended table to ensure that only unique products are kept in the final result.

In my opinion it is wrong! We need first of all to import the two tables from excel, then we have to append queries and finally we need to remove duplicates. So the solution would be: D-E-B

actually it would be append table 1 to table 2

why we need to append these tables, because to append the table the structure of the tables should be same. But here the structure of the tables are not same

Import From Excel Append Remove Duplicates

Answer is incorrect... who decided that it was correct? This is misleading and confusing. 1) Import from Excel 2) Append 3) Remove Duplicates

Import Append Remove duplicates

You need to import the tables first. And removing Error is not a necessary step specially in this case, there won't be any errors to remove. I think the best answer is: 1. From Power BI Desktop, import the data from Excel, and select Tabel1 and Table2. 2. From Power Query Editor, append Tale2 and Table1. 3. From Power Query Editor, select Table1, and then Remove duplicates.

Solution IS CORRECT because: tested and validated solution: create an excel sheet with one table in each sheet. THEY MUST BE TABLES (ctrl+t) In PBI Desktop create New report -> click transform data: opens query editor -> New Source : excel -> select Table1 & Table2 (DO NOT SELECT SHEETS!!) ->Power Query > Home > Combine > Append Queries > table to append : select Table1 The major difference between Append table 1 to table 2 is the order of data after append. To get the right order as in the question, you select Table2 and you append Table1 to it. Right click Products Header > Remove Duplicates Result is exactly what is shown is question: Products abc xyz tuv mno pqr stu def ghi jkl