I need to create reports based on the Infopaths submitted in the forms library. This library will act as data source for my reports (reports like how many forms are submitted / some pie charts etc.) What I'm doing here to find, if forms library can be pulled in Excel 2010 PowerPivot as a data source (just like any other SP list / library using Export as Data Feed), if so several interactive reports can be created.
I can do PowerPivot reports (Power Views) for other lists / libraries where I can see the "Export as Data Feed", but not Forms library. Am I missing something here or it's just by design and forms library is no supported as data source for PowerPivot ?
... Any Advise or Comments ?