SEARCH
You are in browse mode. You must login to use MEMORY

   Log in to start


From course:

POWER BI [PI-300]

» Start this Course
(Practice similar questions for free)
Question:

You connect Power Query Editor to a database table. You need to remove the Row ID column. Your solution must ensure that new columns do NOT display in the table model during a scheduled refresh in the future. What transformation should you use? Select only one answer. Select Row ID, then use the Remove Other Columns command. Use the Remove Column command on the Row ID column. Use the Select Columns command and chose the columns to keep. Use the Transpose command, then filter the rows to remove Row ID.

Author: da-bi



Answer:

Use the Select Columns command and chose the columns to keep. This answer is correct.


0 / 5  (0 ratings)

1 answer(s) in total

Author

da-bi
da-bi