![]() ![]() 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.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |