we developed a PowerPivot Workbook and published on our PowerBI site based on a Sharepoint Online E3 subscription.
We use it to display PowerView Dashboard and analyse sales results.
On-prem we also have a Reporting Services (stand alone installation) server where we have reports the connect directly to our datawarehouse based on a MS Sql Server DB instance.
What I would like to do is to develop a report in SSRS that connects to the PowerPivot Workbook published on our Sharepoint Online/Power BI site.
I tried following the instruction in this article http://msdn.microsoft.com/en-us/library/gg413489(v=sql.110).aspx but using an URL like https://mycopmany.sharepoint.com/sites/BI/Documents/Workbook.xlsx and the correct Sharepoint Online credentials to access
the PowerPivot Workbook, I always get a "File Not Found" error.
I would like to know if what I would like to do is possible and how to do it.