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)

Correct answer

I agree that removing errors is a good practice but importing the data is necessary here. this should be the correct sequence: import table 1 and table 2 with table 1 selected append table 2 into table 1 remove the duplicates from the resulting table 1

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