Microsoft Office Tutorials and References
In Depth Information
Moreover, IT will really like the fact that you are reading data from views because—from their
point of view—the view acts as an interface between the database and the users asking for
data (you, in this case). When IT people look at views, they are aware of the data you are using.
We recommend that you use views because a view acts as a perfect bridge between the
complexity of SQL queries (which is left to IT staff) and the simplicity of tables.
Opening Existing Connections
In the preceding section, we showed you all the features and stages of data loading, creating
a connection from the beginning. After you create a connection with a data source, it will be
saved in the PowerPivot workbook so that you can open it again without needing to provide
the connection information. Unfortunately, this useful option is not so easy to find because it
is on the Design tab of the PowerPivot ribbon, as you can see in Figure 5-12.
FIguRE 5-12 The Existing Connection button on the Design tab.
If you click this button, PowerPivot opens the Existing Connection dialog box shown in Figure
5-13, where you can select either the connections saved in the Excel workbook or any local
connection previously saved in your document library.
Moreover, if you need to change the properties of a saved connection, you can use the Edit
button to open the Edit Connection dialog box again and update its configuration.
Note It is very important that you get used to reopening existing connections whenever you
need to import more tables from the same database because, if you create a new connection
each time you want to load data, you end up with many connections in the same workbook. If
you have many connections and you need to modify some of the connection parameters, you
will have some extra and unneeded work to update all the different connections. Moreover, if
you have fewer connections, performance might improve, and there is less administrative effort
in handling external connections whenever the workbook is published on SharePoint.