EMERGENCY || Connecting Redshift via SSH Tunnel

[PremK]

My Org. have 3 reports working in Service, which uses AWS Redshift as Data source. 
since the data is very confidential and it  belongs to US people, my Org ( located in India ) used AWS KIOSK in initial days. with this kiosk they enabled Cloud gateway connection in PBI Service to AWS Redshift and the gateway worked good. 
but later we came out of this kiosk, and from this time the cloud gateway connection stoped working, and we couldn't restart the gateway connection.
so we created a SSH tunnel with Bastian host in Redshift to creat a connection between Redshift and PBI.
but we are not aware of how to connect this SSH tunnel with PBI.

NEED AWS SPECIALIST HELP IN THIS TO CONNECT POWER BI SERVICE AND REDSHIFT USING THIS SSH TUNNEL BASTION HOST

[hackcrr · Accepted solution]

Hi, @PremK 

Use the SSH command to set up the tunnel. This can be done on a local computer or on a server that Power BI can access. The command is usually shown below:

ssh -i /path/to/private-key -N -L localhost:<local-port>:<redshift-endpoint>:5439 ec2-user@<bastion-host-ip>

Open Power BI Desktop>>Go to Home>> Get Data>>Setup ODBC Data Source: Open the ODBC Data Source Manager on your machine. Add a new data source and configure it to use SSH tunneling

In the Power BI service, go to Settings > Manage Gateways.
Add a new data source to the gateway and configure it to use the same ODBC data source you set up in Power BI Desktop.

hackcrr

If this post helps, then please consider Accept it as the solution and kudos to this post to help the other members find it more quickly