Database Reference
In-Depth Information
Calling Stored Procedures Directly
from Power Pivot
In Chapter 4, you explored some of the ways to pull data from SQL Server directly into Power Pivot.
This works great for tables and views, but there is no way to call a stored procedure without writing
an SQL statement.
Luckily, Power Pivot gives you the option of writing your own SQL statements. Follow these steps:
1. Open the Power Pivot window and click the From Other Sources button on the Home tab.
The Table Import Wizard opens.
2. Select the Microsoft SQL Server option and click Next.
The Table Import Wizard asks for all the information it needs to connect to your database (see
Figure 11-15).
Figure 11-15: Provide the basic information needed to connect to the target database.
 
Search WWH ::




Custom Search