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,
Thanks for this. So it is possible in theory but in practice it's nessecary to manitain a weekly changing list of Azure public IP addresses...?
stevenc,
Yes. If you are blocking outbound IP traffic, it's necessary to whitelist the Azure Datacenter IP addresses. There is a similar thread for your reference.
http://community.powerbi.com/t5/Service/Firewall-setup-IP-used-by-Power-BI-Service-during-data-refresh/td-p/135643
Regards,
Lydia