Your browser does not support video.

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.
     

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Any additional feedback? (Optional)

Thank you for your feedback!

×