Forum Discussion
Not able to refresh Semantic model which is using AWS redshift DB.
- 1 year ago
Hi TusharGaurav
The issue you're encountering—where Power BI Desktop can connect to your AWS Redshift database but Power BI Service cannot—is due to network accessibility differences between the two environments. Power BI Desktop operates from your local machine, which has direct access to the Redshift database, whereas Power BI Service runs in Microsoft's cloud infrastructure and cannot access your private Redshift instance unless it is publicly reachable or a secure bridge is established. The most reliable and secure solution is to use an on-premises data gateway installed on a machine within your network or cloud environment that can access Redshift. This gateway acts as a bridge, allowing Power BI Service to securely communicate with Redshift during scheduled refreshes. You’ll need to configure the gateway, register the Redshift data source with it, and bind your dataset to use the gateway in Power BI Service. Without this setup, Power BI Service will be unable to reach your Redshift instance, resulting in connection timeouts like the one you’re experiencing.
Hi TusharGaurav
The issue you're encountering—where Power BI Desktop can connect to your AWS Redshift database but Power BI Service cannot—is due to network accessibility differences between the two environments. Power BI Desktop operates from your local machine, which has direct access to the Redshift database, whereas Power BI Service runs in Microsoft's cloud infrastructure and cannot access your private Redshift instance unless it is publicly reachable or a secure bridge is established. The most reliable and secure solution is to use an on-premises data gateway installed on a machine within your network or cloud environment that can access Redshift. This gateway acts as a bridge, allowing Power BI Service to securely communicate with Redshift during scheduled refreshes. You’ll need to configure the gateway, register the Redshift data source with it, and bind your dataset to use the gateway in Power BI Service. Without this setup, Power BI Service will be unable to reach your Redshift instance, resulting in connection timeouts like the one you’re experiencing.