Redshift error in power bi service with direct connect

[SOLORAJG2]

he credentials you provided for the data source are invalid. Please check the credentials for all the data sources.Hide details

Activity ID:	126020c6-92d8-b91d-2189-cd3020dca348
Request ID:	db372f48-6f4c-6fe0-a338-e66812b2580b
Status code:	400
Time:	Thu Oct 26 2017 19:45:43 GMT+0000 (Coordinated Universal Time)
Version:	13.0.2819.181
Cluster URI:	https://wabi-west-us-redirect.analysis.windows.net

I am getting above error when powerBI is getting connected with Redshift using direct query

[v-shex-msft]

HI @SOLORAJG2,

Credentials which you input at power bi desktop side not auto transfer to power bi service. After you publish this report to power bi service, you need to manually update the credentials at 'settings -> datasets -> data source credentials'. 

In addition, if above not help, please provide more detailed information about this issue.

Regards,
Xiaoxin Sheng

[lthatcher]

Hello Xiaoxin, sorry to resurrect this post, but is there a way to update the credentials without a human manually doing so? Can I do so through the REST API? If not, this is very bad as we were hoping to use power bi services to distribute content to our client, each with their own dataset and having to have a human touch every dataset every deployment is unscslable and unworkable.

Many thanks