Unable to set enterprise gateway for the data source(ODBC)

[nediga]

Unable to set enterprise gateway for the AWS Redshift data source(connecting through ODBC), after publishing the report data source is not refreshed with the on-premises database.

I have gone through various questions but none of them were similar to mine.

Any help is much appreciated.

[Anonymous · Accepted solution]

@nediga,

What error message do you get when you add ODBC data source or refresh the dataset in Power BI Service? 

I would reocmmend follow the guide in the similar thread below to add ODBC data source within gateway.

https://community.powerbi.com/t5/Service/Enterprise-Gateway-with-ODBC/td-p/98959

Regards,
Lydia