Cannot access dashboard in Power Bi Service connected via Redshift Direct Query

[ashwanth_pasu]

I can connect to redshift with desktop but not via the service. When I publish the report to the service, it asks me to give the credentials for redshift, but when i do that I get this following error everytime

"IThe credentials you provided for the data source are invalid. Please check the credentials for all the data sources

Did anyone solve this issue?

Activity ID:	5095b88e-1487-4abb-9428-6f090e751768
Request ID:	0e06c0c0-b0ca-0df8-05c5-7f9c086fafed
Status code:	400
Time:	Wed May 10 2017 17:10:57 GMT+0530 (India Standard Time)
Version:	13.0.1700.2027
Cluster URI:	https://wabi-us-east2-redirect.analysis.windows.net

[v-sihou-msft]

@ashwanth_pasu

Make sure you use the hostname that matches the server certificate when connecting Redshift.

Regards,

[ashwanth_pasu]

Where do I find the host name ? U mean the URL? I think that is right and I cannot edit that path in power BI

as far as the user name and the pwd is considered I have used what I always use to access Redshift database,