Power BI service- Redshift Direct Query connectivity

[Anonymous]

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://powerbi.microsoft.com/en-us/blog/announcing-support-for-amazon-redshift-reports-in-the-power...

https://community.powerbi.com/t5/Service/Can-not-Connect-PowerBI-com-to-Redshift/m-p/165661#M23015

[Anonymous]

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]

@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!

[Anonymous]

 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

[Anonymous]

@Anonymous

Its request are dynamic and not have static ip range. 

Does your statement is true for the Power BI Premium capacity as well? Lets assume that we configure P1 capacity node.

https://docs.microsoft.com/en-us/power-bi/service-premium

[Anonymous]

Hi @Anonymous,

Unfortunately, premium license also not improved ip range part.(it improve refresh related performance but still not use static ip ranges)

Regards,

Xaoxin Sheng

[avigdorth]

This is a huge issue for our company as well. Our EDW is in a private Redshift DB and our security team, understandably so, doesnt want to whitelist a dynamic IP range essentially rendering the benefits of a private DB useless. If this cannot be fixed, we will be forced to move at least some of our BI tools to another platform that supports DQ private Redshift DBs.