Forum Discussion
Power BI service- Redshift Direct Query connectivity
Apologies for open a new thread as this topic has not been answered [as per my search].
Ask: Power BI service needs to connect Redshift database in Direct query mode. Redshift is in a VPC [private subnet] and there is no inbound rule right now to allow Power BI request.
After reading the below article and thread, looks like this question still open. This link provides the IP ranges for the Azure regions. This is lot of IP Address [Virginia, East US2 case] and these many cannot be added in Redshift inbound rule; also not sure how frequently this could change.
This is one of the important use case that Microsoft needs to address to position the Power BI as a enterprise BI platform. Any assistance is much appreciable. Thank you!
https://community.powerbi.com/t5/Service/Can-not-Connect-PowerBI-com-to-Redshift/m-p/165661#M23015
6 Replies
HI Anonymous,
Did you means amazon redshift white list size limit to add azure data center ranges ip addresses?
In my opinion, I think this issue is more related to amazon itself, I'd like to suggest you contact to amazon developer team for better support.
BTW, if amazon still not allow you to increase white list size limit, you can also considered to submit this requirement to ideas forum.
Regards,
Xiaoxin Sheng
Anonymous
Thank you for your response. This is not about the limitation in the AWS and this is more of our company security policy that allow requests from bunch of IP Address in the inbound rule. Also, this list could change in the future.
Do we have any alternate solution? Something like Pro vs Premium capacity. Your quick response is much appreciable. Thank you!
Hi Anonymous,
Unfortunately, I also not found an effective function to resolve this situation. Its request are dynamic and not have static ip range.
Maybe you can consider to setup a proxy server to handle power bi requests.
What is a Proxy Server and How Does it Work?
Regards,
Xiaoxin Sheng