O'Reilly logo

SQL Server 2012 Reporting Services Blueprints by Mickey Stuewe, Marlon Ribunal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

  1. 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:
    Adding a data source to a model
  2. In the COM Add-Ins dialog box, select Microsoft Office PowerPivot for Excel 2013 and Power View. Click ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required