Forum Discussion
PowerBI Service connect to AWS Redshift Serverless directly and not via On-Prem Gateway on EC2
- 2 years ago
Checkout these 2 links for further details:
Integrate Power BI with Amazon Redshift for insights and analytics | AWS Big Data Blog
Solved: Redshift Scheduled Refresh without a Gateway...? - Microsoft Fabric Community
Hi,
In PBI desktop one can connect directly to Redshift, however once published into PBI service for the sources to refresh a gateway needs to connect to within the AWS Redshift env an on-prem gateway is configured on EC2
With AWS not being a microsft an on-prem software needs to be installed on aws and the option is EC2
Please help, can you give more detail or provide examples please?
How would the service source view/connect to an VPS AWS Redshift?
Hi,
My other connections such as API using power query or PowerBI REST API Custom Connectors
require an On-Prem Gateway?
That would mean i need the EC2?
Please Advise