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

Using R To Hit Azure ML From Power BI

Leila Etaati shows how you can use R to hit an Azure ML endpoint to populate a data set in Power BI: You need to create a model in Azure ML Studio and create a web service for it. The traditional example in Predict a passenger on Titanic ship is going to survived or not? […]

Read More

Transforming To Proper Case In Power BI, With Exceptions

Imke Feldmann wants to transform text into proper case, but certain words should have their own casing style: The overall strategy is to convert everything to proper case first and then use a translation table to convert the keywords from the table back to their desired values. The following steps show how to do it: […]

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