POWER BI [PI-300]: You have a query named FactSales that retrieves data from a SQL Server table. You need to update the query to prevent new columns that may be added to the table in the future from getting imported during dataset refreshes. You select the existing columns in the query. Which two applied steps can you use in Power Query Editor to achieve the goal? Each correct answer presents a complete solution. Select all answers that apply. Choose Columns Remove Columns Transpose Remove Other Columns

Question

You have a query named FactSales that retrieves data from a SQL Server table. You need to update the query to prevent new columns that may be added to the table in the future from getting imported during dataset refreshes. You select the existing columns in the query. Which two applied steps can you use in Power Query Editor to achieve the goal?  Each correct answer presents a complete solution. Select all answers that apply.  Choose Columns Remove Columns Transpose Remove Other Columns

da-bi · Accepted Answer

Choose Columns
This answer is correct.

Remove Other Columns
This answer is correct.

POWER BI [PI-300]

Choose Columns This answer is correct. Remove Other Columns This answer is correct.

Author