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

Question

If so, does anyone know where are documents and samples.

Answer 1

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

 

Answer 2

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.

Answer 3

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