Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am looking to setup a seamless connection between Power BI and Redshift.
Below is my configuration -
- Redshift in VPC
- Power BI Desktop in on premise machine.
I have whitelisted on premise machine that has access to VPC through direct connect.
With above config able to connect Redshift database from Power BI desktop.
Now with the architecure that was posted for Redshift to Power BI integration -
is it must to have data gateway?
If yes why? Does is it make data accessible at all times even when the power BI report is published?
Thanks.
Solved! Go to Solution.
Hi @ktaws ,
Since Redshift is a cloud service, there is usually no need to use an On-Prem Data Gateway.
However, in your scenario, Redshift is in VPC ( Virtual Private Cloud ). Based on the official document, one gateway is needed.
Question: Do I need a gateway for cloud data sources, such as Azure SQL Database?
Answer: No, services can generally connect to cloud data sources without a gateway. However, you might need a data gateway if your data sources are behind a firewall, require a VPN, or are on virtual networks.
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
Hi @ktaws ,
Since Redshift is a cloud service, there is usually no need to use an On-Prem Data Gateway.
However, in your scenario, Redshift is in VPC ( Virtual Private Cloud ). Based on the official document, one gateway is needed.
Question: Do I need a gateway for cloud data sources, such as Azure SQL Database?
Answer: No, services can generally connect to cloud data sources without a gateway. However, you might need a data gateway if your data sources are behind a firewall, require a VPN, or are on virtual networks.
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
@ktaws , Other then few databases, where power bi serice can connect directly. You need to have Data Gateway and it need to up and running to refresh the data
refer: https://radacad.com/the-power-bi-gateway-all-you-need-to-know
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
96 | |
80 | |
67 | |
62 |
User | Count |
---|---|
137 | |
106 | |
104 | |
81 | |
63 |