cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
BILLLAIQUR
Regular Visitor

advance option to run SQL query in Redshift

Hi,

 

We recently moved to AWS environment where we are trying to use Power BI to connect with Redshift using direct query. It's working perfect but we couldn't use SQL queries on top of it using Advance option (usually exist if i connect with SQL Server) to alter\minimise the datasets. Is This option not available in Redshift? Any reason why is that or any alternatives that i can think about.

 

Regards,

 

Laiq

3 REPLIES 3
Moderator v-yuezhe-msft
Moderator

Re: advance option to run SQL query in Redshift

 

@BILLLAIQUR

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 textbox. However, in this case, only import mode is available.

Regards,
Lydia

 

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BILLLAIQUR
Regular Visitor

Re: advance option to run SQL query in Redshift

Thanks lydia. Hope there will be solution in future to use sql queries for direct query
Moderator v-yuezhe-msft
Moderator

Re: advance option to run SQL query in Redshift

@BILLLAIQUR,


You can submit an feature request in the Power BI ideas forum.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors