Forum Discussion
gateway connectivity issues
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
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.
4 Replies
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.
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.
Hi mownica,
Checking in to see if your issue has been resolved. let us know if you still need any assistance.
Thank you.
