Change PerformancePoint data source connection programmatically RRS feed

  • Question

  • I have around 900 reports which are using 40+ data sources. All of them are stored in SharePoint Data connection library. Is there any way to change the connection string of those data sources programmatically? The only way I have found is to open each data source individually and then change the server name.

    I believe with PPS API it could be possible but I am not able to find any sample to do that. All I have to do is to read the data source connection string and then change the server name, so that when next time user refresh the report it will be mapped to new server analysis server.

    Glad to help! Please remember to accept the answer if you found it helpful. It will be useful for future readers having same issue.

    My Profile on Microsoft ASP.NET

    Wednesday, January 18, 2017 5:52 AM