Forum Discussion

mownica's avatar
mownica
New Member
10 months ago
Solved

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 ...
Need Help
  • v-saisrao-msft's avatar
    v-saisrao-msft
    10 months ago

    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.

GilbertQ's avatar
GilbertQ
Super User
10 months ago

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.