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. Choose Columns Remove Columns Remove Other Columns Transpose

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.  Choose Columns Remove Columns Remove Other Columns Transpose

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