Import single column from Dataverse

[quarterpress]

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.

[Greg_Deckler · Accepted solution]

@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.

[Greg_Deckler · Accepted solution]

@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.

[quarterpress · Accepted solution]

Awsome! Thank you so much. I didn't know you could click the gear thing and see the columns.