Connecting Power BI Service to AWS Redshift Outside Our Organization

[JoseAmal]

Hi everyone,

I’m new to using cloud platforms with Power BI and need some assistance. We have an AWS Redshift data warehouse managed outside our organization. They have whitelisted our organization’s IP to allow inbound requests, as we were previously using Power BI Report Server. However, since we couldn’t schedule refreshes on the report server, we decided to move to Power BI Service to get live data.

This Redshift instance is not publicly open to the internet. I’ve installed the ODBC driver on my system and can access the Redshift data locally. I successfully published my dashboard to my workspace. However, when I try to update the credentials in the semantic model, I encounter the following error:

Failed to update data source credentials: ODBC: ERROR [08S01] [Microsoft][Amazon Redshift] (10) Error occurred while trying to connect: [SQLState 08S01] timeout expired

What am I missing? Is there any gateway setup that needs to be done? Any help would be greatly appreciated.

Thank you!

[KNP · Accepted solution]

From my limited experience with Redshift, you'll need a gateway setup with the ODBC driver installed on the gateway machine(s).