Connecting to private Amazon Redshift from PowerBI service

Question

How can I connect Redshift from PowerBI online service, and redshift is a private subnet not open to internet

Answer 1

Follow the steps:

1. Install  Windows Server EC2 in the private subnet as the Redshift cluster 
2. Download  Microsoft On-Premises data on EC2 instance.
3. Then Install Amazon Redshift ODBC Drivers on EC2
4. Go to  Power BI service > Manage Gateways, add a new Data Source to the Gateway. 
5. Publish the report and dataset

Want to learn more about Power Bi, CheckOut: Power Bi tutorial