on 08 Jun 2017 22:16:29
The direct connection of Power BI to Redshift does not work properly since it is not possible to add the Microsoft Azure Datacenter IPs in Redshift security configuration.
The IP range is too long (over 270 different IPs) and goes over the admissible limit for inbound rules in Redshift
- Comments (3)
RE: Power BI direct connection to Redshift inbound rules
We need to schedule Data Refresh from Power BI Service to AWS Redshift.
Please provide inbuilt support to white list the PBI Service on AWS Security Group, in next release.
Many customers are using cloud services(like AWS/Azure) to fetch data into Power BI.
Help in next release.
RE: Power BI direct connection to Redshift inbound rules
very much needed to build PBI support in enterprise accounts with AWS DW assets.
RE: Power BI direct connection to Redshift inbound rules
The solution would be to add redshift support into the powerbi gateway! We face the same problem, that our customer does not want to user powerbi service just because he cannot filter inbound connections based on an ip address of the powerbi service since the azure ip address range is so vast and powerbi service is hosted on an unspecified ip within that range. We currently use powerbi gateway with a generic odbc connection to redshift! While this solves our security problem, we do not have direct query support - of course - and this is a major drawback in the longterm when query performance becomes an issues. So, please, add redshift support to the powerbi gateway!