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