Press "Enter" to skip to content

Spelunking In The SSRS REST API

Chris Webb uses Power BI to look at the new SQL Server Reporting Services 2017 REST-based API:

And the online documentation for the API is here:

https://app.swaggerhub.com/apis/microsoft-rs/SSRS/2.0

Interestingly, the new API seems to be OData compliant – which means you can browse it in Power BI/Get&Transform/Power Query and build your own reports from it. For example in Power BI Desktop I can browse the API of the SSRS instance installed on my local machine by entering the following URL:

This is something that SSRS has been missing for a long time.  I’m glad they’re introducing a real API.

One Comment

  1. SQLBlogNL
    SQLBlogNL 2017-10-25

    Hi Chris,

    Have you tried this new REST API? We are investigating the possibilities to integratie SSRS into SalesForce. There need to be some kind of authentication between SalesForce and SSRS. When a client logs in, the API should only return folders and reports the client is allowed to see. There’s no active directory so I don’t know the possibilities. Any idea if this is technical possible?

    We are using the same kind of authentication in a custom portal internal using the reporting services Report Viewer Control but this is in an active directory.

    I was thinking about an Iframe integration or something but maybe we can use this new API. There’s not much documentation about this.

Comments are closed.