Part V: Understanding Power Pivot and Power Query
FIGURE 41.1
Hover over a query to get quick information including sneak peeks of column contents.
Organizing queries in groups
As you add queries to your workbook, your Queries & Connections pane may start to feel
cluttered and disorganized. You can get organized by creating groups for your queries.
Figure 41.2 illustrates the kinds of groups that you can create. You can create a group for
specific stages of data processing. Or how about a group for queries sourced from external
databases? What about a group where you store small reference tables? Each group is col-
lapsible, so you can neatly pack away queries that you aren’t working with at present.
You can create a group by right-clicking a query in the Queries & Connections pane and
selecting Move To Group ➪ New Group. Right-clicking the group name will expose a set
of options for managing the group itself (see Figure 41.3). You even have the option of
refreshing all of the queries within the group at once.
