M365 Excel - Add data and then refresh your query

Finally, add data to your data source and then refresh it in Excel. Power Query automatically applies each transformation you created. This means you only need to create a query once and then you can run it whenever you want.

1. Add three rows of data to the current Sales Data table. To confirm the bonus calculation formula, add one record that's over $25,000.

   Apples	Andrew Cencini	2/14/19	25,000
   Pears	Jan Kotas	2/14/19	35,000
   Beer	Nancy Freehafer	2/14/19	15,000

2. After you finish entering the data, Select Table Design > Refresh All.
   
   After Excel finishes refreshing the data, confirm the results in the PQ Sales Data worksheet.

   Note   If you're manually entering new data or copying and pasting it, make sure you add it to the original data worksheet and not to the Power Query worksheet.