Forum Discussion
Powershell script to change Datasource Test to Production
Does someone have a powershell script to change the data source? For example I want deploy my report to powerBI reporting service from Test to Productios therefore i need to change the datasou...
(Responding to fbeekvel)
Everything I've tried to change the ReportServer connection string, including all 3 articles you've attached. The connection string is local to the file, and the file only. The connection string is read-only in the ReportServer.
I'd love to be proven wrong, but I don't think it's possible. One possible way is to zip the file and change the connection string text, then zip it back up. That's not enterprise-grade though so I haven't pursued it.
I'm pretty sure It works. I have a working script somewhere, I'll see if I can post it tomorrow.