Forum Discussion
Solved
How do I create an advanced SQL query with an AWS Redshift database in powerbi service
I am basically self teaching how to use powerbi service and I am absolutely lost. All of my data is stored in a redshift cluster after hours of trying to figure things out I managed to get a dat...
Yeah I had to set up a gateway on an EC2 server then add ODBC to it for me to do an advanced query. My main issue was that the redshift connector in desktop allows for an SQL query while the online version does not. The only way to get around this was instead using ODBC
