Can we programmatically create a PowerPivot workbook by importing data from a report?

All Replies

• Tuesday, July 19, 2011 2:02 AM

   

   
  

  0

  Programmatic creation of PowerPivot workbooks is not supported in this release.

   

  • Proposed As Answer by T.K. Anand Tuesday, July 19, 2011 2:02 AM
  •  
   
• Tuesday, July 19, 2011 11:58 AM

   

   
  

  0

  Thank you for your reply.

  Do you mean it will be supported in the final release?

  For importing data from table & view, will it support programmatically provision a data filter?

  And For importing data from a query, will it support getting data from a stored procedure which requires a parameter now? And in the final release, can this be automated?

  From my point view, without these features, the PowerPivot really cannot be called self-service analytical tool for everyone. At the most, it can only be used by professional analyst.

   
• Thursday, July 21, 2011 1:22 PM

   

   
  

  0

  For our company, we have a set of data security policy, data availability to a user is defined by a set of user secure policy role. for majority sales folks they only have access to the data of their own business. that is why programmactically filter data by uer login/ user role, it is a must to us in order to let sales folkes to adopt the tool.

   

  And many our existing reports have more than 5 parameters, some of parameter values are impossible to let a non-tech user to fill in the "import from report" window. This is another reason for us need a programmatic creation of  powerpivot support.

   

  does anyone know, in final release of the product, willthose features be available?

  Thanks