powerbi - Power BI - Update Connection Strings via API for AWS Redshift -

here planning achieve:

we have created reports using aws redshift data source. and, can publish pbix files workspace using create import api(msdn.microsoft.com/en-us/library/mt243840.aspx)
we trying update connection string on datasets using datasource api set connections(msdn.microsoft.com/en-us/library/mt748181.aspx)

i'm newbie power bi.. seeking guidance...

let's say, developed report pointing aws redshift on development environment. trying automate publishing developed report qa or staging or production environments;
means published report have point aws redshift on qa or staging or production environments.
today, when upload pbix file, power bi service prompts provide credentials. doesn't allow change server information. and, want ability change or point different server. here appreciated.
this means, we'd have create reports specific each environment , not want.
we under impression set connections api come-in handy us. but, don't know how produce connection string point report different aws redshift
database.
so, decided take crude approach, create report each against qa or staging or production aws redshift. query and
retrieve connection string each reports' datasource. this
gave mashup connection strings' -
provider=microsoft.mashup.oledb.1;data
source=$embeddedmashup(blah-blah-blah-blah)$;extended
properties="blah-bhaj-blah-blah-blah-blahblah-bhaj-blah-blah-blah-blah-blah-bhaj-blah-blah-blah-blah-blah-bhaj-blah-blah-blah-blah=", if observe connection string, you'll see extended properties... encrypted information, not sure what
information encrypted string holds. and, in case create
different looking reports, extended properties come out
different means cannot have standard
mashup connection string. and, crude approach won't fly.

so, information seek how point report developed against aws redshift environment point different aws redshift?

wiki

tL