Power Query Editor - New Query / Enter Data

[gheyman]

I see that when you are in the Editor that you can create your own table there and add data. But once you do so, can you go back into that table and add more rows? I don't see how to add data once the table is created. I wouldn't be entering data on a regular basis, just if something needed to be added in the future. Thanks for the Help!

 

[Alex Blakenburg]

In the Source step of the manually input table query, click on the the Gear icon and it will put you back into the Table in edit mode.

 

[gheyman]

Thanks!

 

[Alex Blakenburg]

No problem. Glad I could help & thanks for the feedback.