Forum Discussion
Connecting Redshift Spectrum to PowerBI
Hi all, We are looking ways to connect PowerBI to AWS S3 buckets and one of the solutions we are analyzing is to use Redshift Spectrum (rather than AWS Athena). However, I've been searching if t...
Sorry MarcSitges
I misread, i think it's a similar setup as i explained here is the documentaion and driver links https://docs.aws.amazon.com/redshift/latest/mgmt/configure-odbc-connection.html
Yes, here is the connectivity with Redshift although my suspition is that the connection with Redshift Spectrum only works when datasources from Redshift Spectrum comes from Redshift DB, not in the case of coming directly from S3.
I would need some confirmation on this last thing.