Forum Discussion

icassiem's avatar
icassiem
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

PowerBI Service connect to AWS Redshift Serverless directly and not via On-Prem Gateway on EC2

Good day,   I have sources from ERP/CRM salesforce/NetSuite directly to powerbi services I have product data within AWS Redshift and am setting up an EC2 instance to configure the On-Prem Gateway ...
Need Help
amustafa's avatar
amustafa
Icon for Solution Sage rankSolution Sage
2 years ago

In Power BI Service or Desktop you can connet directly to Amazon Redshift without EC2 layer. Why you need EC2 and gateway? If it's a VPC issue then creating a new endpoint for external access to Redshift.

icassiem's avatar
icassiem
Icon for Post Prodigy rankPost Prodigy
2 years ago

Please Confirm, as i would like to pause DevOps of configuring an EC2 instance

 

1. The "Postgresql or Redshift connection from Power to Redhsift" will work with a VPC endpoint for external access correct?

2. Anything PBI/Redshift/AWS require when selecting the postgresql/redshift connection source in service/desktop other than the redshift credentials?

3. Connection string is redshift url? 

 

Has anyone done this previously, some links please?

The below links, suggest its an security risk for VPC enpoint external and not recommended, i really hope not, Real waste to setup EC2 for gateway only

 

Please Help, Thank You