Adding a data source to a model
A data model is the basis for any Power View and PowerPivot.
Let's create that. In this demonstration, I'm using Excel 2013. The difference in Excel 2010 may not be significant. You may want to double check that.
- Open an empty Excel workbook. Check if the PowerPivot add-in is enabled. If you don't see PowerPivot in the ribbon panel, it's not enabled. To enable, go to File | Options | Add-Ins. Under the Add-ins list, select COM Add-ins from the Manage drop-down box, then click on Go, as shown in the following screenshot:
- In the COM Add-Ins dialog box, select Microsoft Office PowerPivot for Excel 2013 and Power View. Click ...