Company is moving some data tables to AWS Redshift - I know I can connect directly to Redshift instance from desktop; but how do I connect it as a gateway instance for refreshes?
I'd like to suggest you turn on 'allow user's cloud data sources to refresh through this gateway cluster' option to allow gateway to handle cloudy datasource:
Merge or append on-premises and cloud data sources
Notice: cloudy datasource not need to be configured under gateway.
Power BI Super User, Greg Deckler, explains
Register by September 5 to save $200
Engage and empower students with Power BI!
Continue your learning in our online communities.