gateway connectivity issues

[mownica]

Hi Community , 

I am trying to set up auto refresh for a dashboard of mine but I am using odbc as the connection and have connected redshift and mysql using odbc for the dashboard 
Now I am able add my sql to the connection but I am not able to add redshift as the connection 
facing the below error 
Can someone help with it

[v-saisrao-msft]

Hi @mownica,

Checking in to see if your issue has been resolved. let us know if you still need any assistance.

Thank you.

[v-saisrao-msft]

Hi @mownica,

Have you had a chance to review the solution we shared earlier? If the issue persists, feel free to reply so we can help further.

Thank you.

[GilbertQ]

Hi @mownica 

What I would also recommend is logging onto your gateway machine making sure you have the valid Red Shift ODBC driver installed and you can successfully connect to Redshift using the ODBC 64 bit driver.

[v-saisrao-msft · Accepted solution]

Hi @mownica,

Check that the gateway machine can access your Redshift cluster by opening the ODBC Data Source Administrator (64-bit) and testing the DSN, or by running ping <your-redshift-endpoint> and <your-redshift-endpoint> 5439 from the Command Prompt. If these tests fail, verify that the gateway’s IP address is whitelisted in your AWS Redshift VPC security group and that there are no firewall rules blocking access. 

Additionally, In Power BI Service, go to Manage Gateways → Data Source Settings, select your Redshift data source, re-enter your username and password with Basic authentication, then click Apply and Test Connection to confirm authentication is successful.

 Power BI gateway and Report Builder support for ODBC data sources - Power BI | Microsoft Learn

Thank you.