Forum Discussion
Post PatronHow to write query in power BI Desktop with Amazon redshift connection
chotu27,
When using the Amazon redshift connector in Power BI Desktop, it is not possible to write SQL queries, we are only able to input server name and database name to get data from Amazon redshift.
As a workaround for this issue, you can create a ODBC data source for Amazon redshift following the guide in this video, then connect to the ODBC data source in power I Desktop, and you can write SQL queries in SQL statement box.
Regards,
Lydia
Advocate Isame issue here. With this solution (connecting using de ODBC driver), it does not allow to use scheduled refresh. We need to be able to query directly using SQL, as we do with our data sources like MySQL. Our database is huge and we cannot import it completely and then filter. We use complexe SQL queries to query our data. This is preventing us from using PowerBI in this case. Using DirectQuery does not allow to do the kind of queries we use in SQL, and it also has the problem that we cannot use other data sources in same PowerBI file. All advantatges of PowerBI are useless if this cannot be done.
Advocate IVThis is an issue here as well. Enabling writing SQL directly against the Redshift datawarehouse would bring it to feature parity with the other database connectors. As it is, I'm using a workaround of creating a view in Redshift, because the ODBC connector is not an option since we need to have it refresh.