How do I use Power Query in Excel?

In the Power Query ribbon tab, click Options. In the Options popup window, choose a Default Query Load Setting. Note: The Query Editor only appears when you load, edit, or create a new query using Power Query. The video below shows the Query Editor window appearing after editing a query from an Excel workbook.
For More Information Please Refer:

You May Also Like to Read: