SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,927 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Using the SSRS REST API , I can deploy a report from PowerShell in an automation pipeline.
But how do I use the API to wire it up to our predefined Shared DataSources?
The PUT Reports({Id})/DataSources endpoint doesn't seem to be for Shared DataSources.
Ok, using Fiddler to watch queries to the report server, I found it makes calls to
PUT .../CatalogItems({id})/Model.Report/DataSources
I don't see that endpoint documented in the Swagger Documentation, but it seems to work.
The body is a list of data source references like this.
[
{
"Name":"MyDataSource",
"Path":"/Path/to/MyDataSource",
"IsReference":true
}
]