Power Query

Add data and then refresh your query

Add data and then refresh your query

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.
     

A subscription to make the most of your time

Need more help?

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×