none
Reporting Services connecting to a PowerPivot Workbook hosted on Sharepoint Online

    Question

  • Hi,
    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.

    Thank you,
    Roberto

    Wednesday, July 02, 2014 9:43 PM