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 kommentar(er)
