Chapter 35: Introducing Power Pivot
35
FIGURE 35.17
The last screen of the Table Import Wizard shows you the progress of your import actions.The final step in loading data from SQL Server is to review and create any needed relation-
ships. Activate the Power Pivot window and click the Diagram View button on the Home tab.
Power Pivot will display the diagram screen where you can view and edit relationships as
needed (see “Creating relationships between your Power Pivot tables” earlier in this chapter).If you find that you need to adjust the filtering you’ve applied to your imported data, you can call up the Preview &
Filter screen again. Simply select the target table in the Power Pivot window and activate the Edit Table Properties
dialog box (Design ➪ Table Properties). You’ll note that this dialog box is basically the same Preview & Filter screen
that you encountered with the Import Table Wizard (see Figure 35.16). From here, you can select columns that you
originally filtered out, edit record filters, clear filters, or even use a different table/view.
Loading data from other relational database systems
Whether your data lives in Microsoft Access, Oracle, dBase, or MySQL, you can load data
from virtually any relational database system. As long as you have the appropriate data-
base drivers installed, you have a way to connect Power Pivot to your data.To connect to any database system, you must have that system’s drivers installed on your PC. SQL Server and Access
are Microsoft products whose drivers are virtually guaranteed to be installed on most machines that you’ll encoun-
ter. The drivers for other database systems, however, need to be installed explicitly. This is typically done by the IT
department either at the time the machine is loaded with corporate software or upon demand. If you don’t see the
needed drivers for your database system, contact your IT department.