Get to know Power Query

Add data and then refresh your query

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

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?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.