Loading Data Directly into PowerPivot

Step 1: First create a table in Excel.

Step 2: Select the table. Go to the Power Pivot tab on the top of the ribbon and then select Add to Data Model option.

Step 3: Create Table dialog box appears. Here select the table range and check my table has a headers option and then click on OK.

Step 4: Then it loads the excel table to Power pivot for excel.

How to Open PowerPivot for Excel

Step 1: Open the new workbook in excel. Go to the PowerPivot tab on the top of the ribbon and then from the data model group select manage.

Step 2: Then it will open a new PowerPivot for the excel workbook.

There are two ways to input data into Power Pivot: Data may be immediately loaded into PowerPivot, populating the database, or it can be loaded into Excel and added to the Data Model. You may either create connections and/or use the existing connections to import data into the Power Pivot Data Model from multiple data sources. Use the second method to get the data for Power Pivot without telling Excel anything. This is due to the fact that the data will only be loaded once and in a highly compressed manner. The SQL Server relational database is one of the data sources that Power Pivot supports. Text files, Excel files, Microsoft Access databases, SQL Server Analysis Services, and many more.