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 ...
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

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,

 
Akash_Varuna's avatar
Akash_Varuna
Super User
1 year ago

Hi Irvanda , 
On-Premises Data Gateway: A tool to securely connect Power BI to private data sources (like AWS Redshift) without exposing them to the internet. Install it on a machine with access to Redshift and configure it in Power BI settings.
https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-install
Power BI IP Ranges: If not using a gateway, whitelist Power BI's IP ranges in Redshift's security group (default port: 5439). Download the updated ranges from

  • v-aatheeque's avatar
    v-aatheeque
    Community Support
    1 year ago

    Hi Irvanda ,

    Akash_Varuna  Thanks for your prompt response.

    Additionally, to connect using DirectQuery with Amazon Redshift, you can refer to the following link: Power Query Amazon Redshift connector - Power Query | Microsoft Learn

     

    If a community member has addressed your query, please mark their response as "Accept Answer" and click "Yes" if you found it helpful.

    Should you have any further questions, feel free to reach out.

    Thank you for being a part of the Microsoft Fabric Community Forum

    • Irvanda's avatar
      Irvanda
      Regular Visitor
      1 year ago

      Hi v-aatheeque,

       

      Thank you for additional information.

      • Irvanda's avatar
        Irvanda
        Regular Visitor
        1 year ago

        Hi v-aatheeque,

         

        I want to asking another question, related to memory and storage models?

        If I use DirectQuery to get data from AWS Redshift, does it still consume the memory model (1 GB) and native storage (10 GB) in Power BI Pro?

         

        Thank you,

  • Irvanda's avatar
    Irvanda
    Regular Visitor
    1 year ago

    Hi Akash,

     

    Thanks for the info, but it seems like there is still something missing regarding the Power BI IP Range from where I need to download.