Creating a SSRS report on a published SharePoint PowerPivot app

Written by Kasper de Jonge

Thursday, 31 December 2009 21:02

I was being triggered by my own remark from my previous blogpost Solving a business problem with Powerpivot CTP3 using DAX Timefunctions where i stated:

I wish i could use this in Reporting services on top of cubes, doing these same things in MDX wil most definitely give us the feared too many rows error.

I decided this had to be possible, when a PowerPivot app is published to SharePoint the data is loaded into SSAS. So this blogpost will describe how we can use reporting services to show data we created in PowerPivot.

First we have to save the App to SharePoint, thanks to Dave Wickert we know manual uploading to SharePoint is the best way to go, resulting in a published PowerPivot App: