Forum Discussion
Import single column from Dataverse
Under "Choose Columns," I deleted a column I now need. It has been too long to undo. How can I import a single column into a table I've already imported? For example, I have a Persons table that I imported. When transforming data, I chose some columns. I left out a column I needed. I want to keep the Persons table I imported, and add to it the column I left out.
quarterpress Go into your query in Power Query Editor, find your Choose Columns step and select your column. Alternatively, use Advanced Editor and find your SelectColumns statement and add it in there manually.
Awsome! Thank you so much. I didn't know you could click the gear thing and see the columns.
2 Replies
quarterpress Go into your query in Power Query Editor, find your Choose Columns step and select your column. Alternatively, use Advanced Editor and find your SelectColumns statement and add it in there manually.
Awsome! Thank you so much. I didn't know you could click the gear thing and see the columns.