Connecting PowerPivot to SSRS Reporting Services RRS feed

  • Question

  • Hi,

    I'm trying to use PowerPivot to connect to an SSRS report. I can see that in principal it's possible, but I haven't got it working yet. This is what I've tried so far...

    From PowerPivot tab (in Excel 2013 Pro Plus)... Manage, Get External Data, From Other Sources, Report, Next>, Browse... (beside Report Path), in Name field enter URL of SSRS report server and press Open button. At this stage I get an error message indicating that either the URL is incorrect or I don't have permission to use the server:

    It's possible that my permissions need to be altered before this will work, but I can run reports from the web interface of this SSRS report server:

    What permissions am I likely to need to look at before I can get PowerPivot pulling from this SSRS report server? For what it's worth, we're currently using SQL Server 2012, and I believe the SSRS version is SSRS 2012.



    • Edited by T Clarke Friday, April 29, 2016 2:54 PM
    Friday, April 29, 2016 2:46 PM


All replies