Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Report Server API pach datasource failing

Hi.   We have a server with possibly hundreds of user created reports the need to have their connectionstrings updated. I've tried to get this to work using the API and a python script but without...
Python
Report Server
REST API
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi.

 

The report only have one datasource and the Id for it is provided in the uri above.

 

Good point using fiddler.

I tried this but realised I cannot change the connectionstring at all i the GUI.

Both fields "Type" and "Connection string" are greyed out.

 

Is this a setting I can change on the server?

d_gosbell's avatar
d_gosbell
Icon for Super User rankSuper User
7 years ago
Anonymous wrote:

The report only have one datasource and the Id for it is provided in the uri above.

So the Id in the uri should be the report Id. The data source Id would then be in the body of the report

 

I tried this but realised I cannot change the connectionstring at all i the GUI.

Both fields "Type" and "Connection string" are greyed out.

 

You definitely can't change the type of the data source. It would break your query if you changed the type. And from what I've seen they only support changing certain types of connections. We primarily have pbix reports in live connect mode and you can change the server/database for those. But I don't know if you can alter data sources for import mode models. These seem to be disabled in the UI, so I suspect the API won't let you change these either