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