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

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

Hi  Irvanda 

In DirectQuery mode, Power BI does not store data in its internal memory. Instead, it sends queries to Amazon Redshift on demand whenever a user interacts with the report. As a result, since the dataset is not physically stored within Power BI, it does not count toward the 1 GB per dataset limit applicable to Power BI Pro.

 

The 10 GB per user storage limit in Power BI Pro primarily pertains to datasets stored in Import Mode. Since DirectQuery does not retain data within Power BI, it does not consume this storage capacity.