Microsoft Office Tutorials and References
In Depth Information
Loading from a SQL Query
In the previous sections, we completed the description of the loading process from a
relational database. During the first step of the Table Import Wizard, you chose to select some
tables and then you followed all the steps to the end. But, as we have seen before, there was
another option: Write A Query That Will Specify The Data To Import (see Figure 5-3).
As you might recall from Chapter 4, SQL is a standard query language for reading information
from a database, and when you select the second option in Figure 5-3, PowerPivot opens the
query editor, shown in Figure 5-10.
FIguRE 5-10 The query editor allows us to specify a SQL query as the data source.
You saw a description of how the query designer works in Chapter 4, so we are not going to
repeat all that stuff here. The interesting part is the fact that, when working with SQL
databases, you always have the option to load tables or queries, whichever looks better for your
specific data model.