It’s always good practice to change the default names of worksheet tabs to names that make more sense to you. Even if you have only two worksheets, one with an Excel table, called Sheet1, and the other a query created by importing that Excel table, called Table1, it’s easy to get confused. It’s particularly important to clarify the difference between a worksheet of data, and a worksheet loaded from the Power Query Editor. Rename worksheet tabs It’s a good idea to rename worksheet tabs in a meaningful way, especially if you have a lot of them. This only occurs when you load the data to a worksheet or Data Model from Power Query. Furthermore, the connected data that you see in an Excel worksheet, may or may not have Power Query working behind the scenes to shape the data. The Power Query Editor ribbon and data previewįor example, manipulating data in an Excel worksheet is fundamentally different than Power Query. The familiar Excel worksheet, ribbon, and grid To avoid confusion, it’s important to know which environment you are currently in, Excel or Power Query, at any point in time.

Know which environment you're in Power Query is well-integrated into the Excel user interface, especially when you import data, work with connections, and edit Pivot Tables, Excel tables, and named ranges.

Office 2016 power query