Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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 [privat...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
Anonymous
Not applicable
7 years ago

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's avatar
    avigdorth
    Frequent Visitor
    6 years ago

    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.