Forum Discussion
Redshift Scheduled Refresh without a Gateway...?
stevenc,
Since Redshift is a cloud service, there is no need to use gateway to refresh the dataset, Power BI service will directly connect to Redshift to keep your reports up to date, for more details, please review the following blog.
https://powerbi.microsoft.com/en-us/blog/announcing-support-for-amazon-redshift-reports-in-the-power-bi-service/
Regards,
stevenc,
Since Redshift is a cloud service, there is no need to use gateway to refresh the dataset, Power BI service will directly connect to Redshift to keep your reports up to date, for more details, please review the following blog.
https://powerbi.microsoft.com/en-us/blog/announcing-support-for-amazon-redshift-reports-in-the-power-bi-service/
Regards,
Hi, Redshift is cloud service but not always is publicly accessible. It depends of the organization´s architecure and security policies.
In our case we have a cluster of AWS Redshift running on a private network on AWS cloud and it means that it is not accessible by internet. We have the same scenario with an AWS RDS (Oracle Database) but, with Oracle Database, we area able to connect through the gateway installed on a Windows Server machine running on the same private network.
I realy think it was a bad mistake of Microsoft that don´t develop a redshift connector for the Gateway. And the argument that a Gateway is not required because it is a cloud service demonstrates immaturity in this type of architecture.
I have been talking to some Microsoft representatives and it seems that there is no alternative but to expose the Redshift database to the internet. In this case this would bring us a considerable security vulnerability.
So, we had to stop the project and maybe rethink the whole architecture due this security gap.