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.

Related Posts

Power Query and the Benefits of Immutability

Chris Webb explains why immutable expressions can be faster to run multiple times than mutable processes: Instead of taking the value #”Sorted Rows”[Column2]{0} and storing it in the variable Column2 then adding Column2 four times, I’m  adding the expression #”Sorted Rows”[Column2]{0} together four times. The query returns the same number as the previous query. However […]

Read More

The Importance of Interaction in Power BI

Marc Lelijveld continues a series on storytelling with Power BI: Many times, I see reports with loads of visuals on the pages. This results in both a really poor performance, as well as the end user has no clue what the key message is of this report. You can always ask yourself, is this visual […]

Read More

1 Comment

  • SQLBlogNL on 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

Categories

October 2017
MTWTFSS
« Sep Nov »
 1
2345678
9101112131415
16171819202122
23242526272829
3031