Forum Discussion
Power BI service- Redshift Direct Query connectivity
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
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.
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
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.
