reporting services - Change SSAS server name in data source of a pbix report programmatically -




using this solution, able upload pbix report on reporting server without issues. tried updating data source information doing following:

var dsinfo = rs.getitemdatasources(report.output + "/" + report.name); //gets data source of report var dsreference = (datasourcedefinition) dsinfo[0].item; //references data source dsreference.connectstring = newconnectionstring; //updates connection string of reference dsreference.credentialretrieval = credentialretrievalenum.store; //sets credential retrieval value store dsreference.windowscredentials = true; //sets windowscredential property true dsreference.username = username; //sets user name through report accessed dsreference.password = password; //sets password through report accessed datasource df = new datasource(); //creates new datasource df.item = dsreference; //assigns reference datasource new datasource df.name = dsinfo[0].name; //assigns reference datasource name new datasource name rs.setitemdatasources(report.output + "/" + report.name, new datasource[] {df}); //replaces datasource report console.writeline($"report {report.name} datasource updated...");

the above code works when access report through repoorting portal. however, when open report using "edit in power bi desktop", throws error saying server name incorrect. on clicking edit, shows me screen can update ssas server name. once server name updated, report works expected.

what should update server name value in pbix file well? gets updated above code on web portal(report works), server name remains unchanged on using power bi desktop.





wiki

Comments

Popular posts from this blog

Asterisk AGI Python Script to Dialplan does not work -

python - Read npy file directly from S3 StreamingBody -

kotlin - Out-projected type in generic interface prohibits the use of metod with generic parameter -