Unable to connect datasource which is in private subnet

[freshket]

I can't connect, test connect or schedule refresh data from my Amazon Redshift that located in my private subnet

[freshket · Accepted solution]

Solved by installing power BI desktop on the computer.

[V-lianl-msft]

Hi @freshket ,

Try to set the privacy level to public.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[collinq]

Hi @freshket ,

Do you have MFA turned on?  Are you using the same credentials and permissions setting in  Desktop and Service?  EIther way, since Redshift is cloud, you don't need to use a gateway.  Is there a reason why you are trying to use a gateway?

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!

[freshket]

Because the redshift is in private subnet. It cannot connect from anywhere.