Reporting Services connecting to a PowerPivot Workbook hosted on Sharepoint Online


  • 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 but using an URL like 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,

    Wednesday, July 02, 2014 9:43 PM