Ability to filter PowerPivots for those who do not have the program?

Category: sql server powerpivotexcel


lee0789 on Mon, 03 Dec 2012 21:20:29

I generated a dashboard consisting of about 15 pivot tables with the PowerPivot add-in.  I created a linked table and did not use SharePoint.  

My goal is to send this dashboard to clients and they can use the filters without having to install PowerPivot.  It works on some graphs but not on others.  It says:

"Initialization of the data source failed.  Check the database server or contact your database administrator.  Make sure the external database is available, and then try the operation again.  If you see this message again, create a new data source to connect to the database."

The data is pulling from a linked table which is within the Excel document itself...so I'm not sure why it's not working for some of the graphs.  

Any ideas? 


Brent Greenwood on Thu, 06 Dec 2012 02:32:49

In Excel2010, the PowerPivot Add-in is required for any users that want to interact with pivot tables that source from PowerPivot models.  No way around that in Excel, because ultimately the PowerPivot engine is what answers the queries generated by changes in filters and interaction with the pivots in Excel.

Some other options:

- publish the workbook to a PowerPivot for Sharepoint intance and let your users interact with the models/pivots in a web browser
     (this could be an on premise SP instance or a cloud PowerPivot provider like PivotStream.com)

- Look into Excel 2013.  Looks like it's shipping for Business clients as of 12/3 and will be generally available 1Q2013.  In Excel2013, PowerPivot is baked into the core Excel product and your users will be able to interact with the pivots and the underlying PowerPivot model without installing a separate Add-in.

Hope that helps. 

Brent Greenwood, MS, MCITP, CBIP
// Please mark correct answers and helpful posts //