What we are doing here is a migration from PowerPivot 2013 to SSAS Tabular. If everything went really well on the "db" side (import in VS2012 and publish on SSAS), we really want to avoid having to redevelop every dashboards already done in Excel using PivotTables.

Letting the PowerPivot Data Model between the Pivot Tables and SSAS is not a solution for us as one of the reasons we did migrate for was to decrease the size of the Excel files (90Mb at the moment, with only 2 years on 10 of historical data).

Despite the adoption of the Data Model in Excel 2013, I'm really surprised that we can't change the data source of a "Power Pivot" pivottable to a Tabular instance. This is a really common scenario that was sold by MS when they introduced Tabular.

Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.