Forum Discussion

Irvanda's avatar
Irvanda
Regular Visitor
1 year ago
Solved

Power BI DirectQuery with AWS Redshift

Hi,

 

I want to subscribe to Power BI Pro, but I need to make sure of a few things.

Can Power BI Pro access data with DirectQuery mode to AWS Redshift (with private network)?

Is it with Power BI IP whitelist on AWS Redshift or what?

 

Thank you,

General Comment
Tutorial Requests
  • Akash_Varuna's avatar
    Akash_Varuna
    1 year ago

    Hi Irvanda ,
    Yes, Power BI Pro can access AWS Redshift in DirectQuery mode via a private network. Use an on-premises data gateway to securely connect Power BI to your Redshift cluster in a private VPC. Alternatively, whitelist Power BI's IP ranges (published by Microsoft) in Redshift's security group for direct access. Ensure proper permissions and optimize queries for best performance.
    If this post helped please do accept this as a solution and give a kudos 

    Thanks In Advance

8 Replies

  • Akash_Varuna's avatar
    Akash_Varuna
    Super User
    1 year ago

    Hi Irvanda ,
    Yes, Power BI Pro can access AWS Redshift in DirectQuery mode via a private network. Use an on-premises data gateway to securely connect Power BI to your Redshift cluster in a private VPC. Alternatively, whitelist Power BI's IP ranges (published by Microsoft) in Redshift's security group for direct access. Ensure proper permissions and optimize queries for best performance.
    If this post helped please do accept this as a solution and give a kudos 

    Thanks In Advance

    • Irvanda's avatar
      Irvanda
      Regular Visitor
      1 year ago

      Hi Akash,

       

      Thank you for the answer.

       

      What do you mean by on-premises data gateway?
      Where is the setting and what is it like?
      Are there any references?

       

      Could you help with the Power BI IP range information?

       

      Please advice,