Wire up a shared dataset in SSRS REST API

Ed Havelaar 1 Reputation point
2024-05-10T03:57:09.2633333+00:00

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.

SQL Server Reporting Services
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,835 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Ed Havelaar 1 Reputation point
    2024-05-13T02:53:00.67+00:00

    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
    	}
    ]
    
    
    0 comments No comments