Forum Discussion

TusharGaurav's avatar
TusharGaurav
Helper III
1 year ago
Solved

Not able to refresh Semantic model which is using AWS redshift DB.

Hi Experts,   I am using AWS redshift DB on cloud and I can connect to the database from the power bi desktop. When I publish the report to power bi service and try to refresh the underlying seman...
  • Poojara_D12's avatar
    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.