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.
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.