Update data source reference in Power View dashboard Sharepoint 2013

private void ModifyDashboardDataSourceReference(string CompanyId, string fileName, string myLibraryName, string dataConnection)
{

ReportingService2010 _reportServer = new ReportingService2010
{
Credentials =
new NetworkCredential(Utility.GetSuperUserByEnv(),
Utility.GetSuperUserPswByEnv(), Utility.GetUserDomainByEnv()),
Url = Utility.GetUrlAbsByEnv() + @»_vti_bin/ReportServer/ReportService2010.asmx»
};

var catalogitempath = string.Format(@»{0}sites/{1}/{2}/{3}»,
Utility.GetUrlAbsByEnv(), CompanyId, myLibraryName, fileName);

var dataSourceArray = _reportServer.GetItemDataSources(catalogitempath);

foreach (var dataSource in dataSourceArray)
{
if (!(dataSource.Item is DataSourceReference))
{
dataSource.Item = new DataSourceReference();
}

((DataSourceReference)dataSource.Item).Reference =dataConnection;
}
_reportServer.SetItemDataSources(catalogitempath, dataSourceArray);

}

• Publicado en: Programación♦SSRS