Step 11: Now, in order to create a KPI report, we need to slice and dice our data under the pivot table. Step 10: After a successful import, you will be able to see the data as below. Step 9: Click on the Finish button once the data table is loaded into PowerPivot. Step 8: Browse the path on where your excel data file is stored and click the Next button to finish the Import.
Select the Excel file, then click on the Next button to proceed further. There you can see a lot of options from where you can import the data to PowerPivot. Step 7: Once you click on the “ From Other Sources” tab, a new window named Table Import Wizard will pop up.
However, if you have an excel file or text file or some data files other than SQL and Access, please click on From Other Sources tab. You can click the Database tab if you want to add data from SQL Server, Access. There are different ways to import data under PowerPivot. Step 6: It should open a new tab named Power Pivot for Excel. Under the PowerPivot tab in your excel file, click on Manage. Select Microsoft Power Pivot for Excel from the list of add-ins and click OK.Īfter enabling this PowerPivot add-in, you should be able to see the PowerPivot option tab on the topmost panel ribbon in your excel. Step 4: As soon as you hit the Go button, the COM Add-ins dialog box will pop up. Step 3: Select COM Add-ins under the Manage section dropdown and click on the Go button.